Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “acceders” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

111 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
acceders133479(None) 
acceder1235361acceder_
accedes1237721accede_s
accede1138302accede__
acceded1336102accede_d
accepters15114602accepters
accorders14144122accorders
accusers12285902accusers
ascenders1235682ascenders
ceders93817672__ceders
cheders134512392_cheders
seceders11277962seceders
abiders104011083a_biders
abraders1137343abraders
accedence1344573accedence
accedences1454163accedences
acceding1446093acceding
accentors13116053accentors
accents113511233acce_nts
acceptees15113693acceptees
accepter14144933accepter_
acceptors15114793acceptors
accepts13356353acce_pts
access1037683acc__ess
accesses1287493accesses
accident13148183accident
accidents14155133accidents
accidias1346333accidias
accidies1338043accidies
accorder1395253accorder_
accouters1344863accouters
accredits1443433accredits
accretes1238113accrete_s
accrues1135323accrue_s
accuser11347933accuser_
accuses114112193accuse_s
acedias1039773a_cedias
achenes12313493achene_s
achievers1743433achievers
ackees124914583acke_e_s
acnodes1037833acnode_s
acrider1038623acrider_
adders84315703a__dders
adherers1296923adherers
aedes64625153a__ede_s
aiders74524633a__iders
alcades101011473alcade_s
alders74218423a__lders
alieners889823alieners
allegers9378233allegers
alterers82512493alterers
ambeers11428923ambe_ers
ameers84015573a_me_ers
amenders11288353amenders
ammeters1237693ammeters
arcades101113193arcade_s
archers124414573arc_hers
ascender1136733ascender_
asceses938623ascese_s
attenders1045273attenders
avoiders1254793avoiders
awarders1245073awarders
bleeders11448453bleeders
breeders11368893breeders
cacklers163710703cacklers
calenders1237403calenders
cancelers13247863cancelers
caperers122611723caperers
carders104820353_carders
careers95218783care_ers
caterers102814403caterers
cedars93312833__cedars
ceder85322243__ceder_
cedes84927333__cede_s
cheder125113493_cheder_
cheers114518913_che_ers
chewers154111143_chewers
chiders135312943_chiders
ciders94620093__ciders
cinders104617763_cinders
codders114114453_codders
coders95426983__coders
conceders1437953conceders
corders104520883_corders
cyders12398833__cyders
deciders123510753deciders
decoders122810413decoders
encoders1137513encoders
exceeders1943283exceeders
feeders113712863_feeders
heders104119763__heders
heeders114213743_heeders
impeders13346593impeders
larceners1135993larceners
needers84111903_needers
parceners1337453parceners
reaccedes1454463reaccede_s
recedes102816063recede_s
saccades13137253saccade_s
schemers1576713schemers
scolders11288993scolders
scowders14276233scowders
screwers13358063screwers
seceder10329573seceder_
secedes103711983secede_s
seders74420283__seders
seeders83017113_seeders
speeders11339313speeders
succeeders1542193succeeders
vocoders1434243vocoders
weeders113412933_weeders

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.440406115.9
2DLD Change Limit1461621117.36019859.0
3Display Results1111110.0462413.0
 (SQL Overall)1786911117.84622774.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.