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 “darers” with Change Limit: [1] [2]

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

240 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
darers7592187(None) 
carers85133961carers
darer65230791darer_
dares66146701dare_s
darners83815771darners
darters84017611darters
daters74827371daters
farers95924051farers
parers85530741parers
adders84315702adders
adorers84411732adorers
agers65027852_agers
airers64922312airers
apers76629132_apers
areas55935772_areas
ares45871022_are_s
armers85520272_armers
avers85127312_avers
bakers125323452bakers
balers85626942balers
barbers114317502barbers
barer74535802barer_
bares75457132bare_s
barkers134318512barkers
barres84427552barres
barters94223052barters
bearers94619592bearers
borers85122682borers
cabers105023922cabers
cagers95624192cagers
caners84629202caners
capers105428142capers
carders104820352carders
careers95218782careers
carer74942332carer_
cares77369182care_s
caress85720262caress
carets85330772carets
carpers114521252carpers
carrs75730852car_rs
carters95327262carters
carvers124817542carvers
caters85336502caters
cavers115026842cavers
corers85231072corers
curers84923192curers
dabbers123813212dabbers
daces85030682dace_s
dackers143417042dackers
daggers103714912daggers
daikers124010312daikers
dales66439742dale_s
damars93815002damars
dames85435852dame_s
dammers123214272dammers
damners104112112damners
dampers123915692dampers
dancers103413092dancers
danders93921182danders
dangers94818212dangers
darbars10510092darbars
darbs85323262dar_bs
dare55848862dare__
dared75935012dare_d
darics94314112darics
darkens12409872darkens
darker114718692darker_
darkeys15356532darkeys
darks106727872dar_ks
darnels83710432darnels
darner74017302darner_
darns66927892dar_ns
darter75320362darter_
darts67635732dar_ts
dashers115016862dashers
dater65332312dater_
dates65639152date_s
daubers104610422daubers
davens104612912davens
dazes155024142daze_s
dealers84118612dealers
dearer74822802dearer_
deers64930522d_eers
defers105116942defers
deters74724682deters
dialers83614302dialers
diapers104713912diapers
dicers94720742dicers
dikers114418792dikers
dimers94321092dimers
diners75525952diners
direr64927072direr_
divers105024962divers
doers65225712d_oers
dopers95522482dopers
dormers104313922dormers
dorpers104113172dorpers
dorrs65520592dor_rs
dorsers83516302dorsers
dosers75723632dosers
doters74423912doters
dowers104523292dowers
dozers164815422dozers
drapers105313352drapers
drawers113610072drawers
drears74614252d_rears
drees65628522d_rees
dregs76114862d_regs
dreks105714752d_reks
dress65319832d_ress
driers74516732driers
dryers10449272dryers
dupers94615602dupers
dures65635922dure_s
duress74712062duress
durrs65519992dur_rs
dyers96617132d_yers
eagers74523682eagers
earners74016452earners
eaters65535952eaters
facers115519442facers
faders105117462faders
fakers134219532fakers
farcers124713442farcers
farer86733142farer_
fares85852872fare_s
farmers124315262farmers
fearers104815272fearers
firers94922682firers
gagers84021332gagers
gamers94420832gamers
gapers94520472gapers
garners83815992garners
garters84218252garters
gaters74728642gaters
gazers164516302gazers
halers94926922halers
harems115513822harems
hares86255542hare_s
harmers124116592harmers
harpers124916202harpers
haters94930402haters
havers124721482havers
hayers124415942hayers
hazers184615952hazers
hearers104319782hearers
hirers94518062hirers
jagers144415722jagers
japers154616172japers
lacers85225252lacers
laders74927762laders
lagers74826142lagers
lakers105225152lakers
larders83516942larders
larees65323112larees
lares54852632lare_s
larkers113014512larkers
lasers64925702lasers
lavers94526362lavers
layers93921182layers
lurers64217492lurers
macers105321272macers
makers123921732makers
mares76457632mare_s
markers133516102markers
marrers93414312marrers
masers84623452masers
maters85032392maters
mazers173917092mazers
namers84517332namers
nares55544152nare_s
oaters65029792oaters
pacers105124542pacers
pagers94423252pagers
papers105125322papers
pareos87023772pareos
parer75839902parer_
pares77164482pare_s
pareus85420742pareus
parkers133816872parkers
parrs75928672par_rs
parsers94118152parsers
paters84935842paters
pavers115021822pavers
pawers114818782pawers
payers114621822payers
racers84725432racers
rakers104123572rakers
rapers84327182rapers
rarer54731702rarer_
rares55247442rare_s
rasers64526782rasers
raters63936582raters
ravers94628182ravers
razers154919612razers
rearers74323562rearers
roarers73812742roarers
sabers85224732sabers
sakers104125432sakers
sarees65329942sarees
savers93825922savers
sawers94620162sawers
sayers94221592sayers
scarers94618512scarers
sharers104720622sharers
snarers74216662snarers
soarers74118092soarers
sparers94519612sparers
starers74522312starers
tabers84621572tabers
takers103923742takers
talers64628152talers
tamers84224032tamers
tapers84025812tapers
tares57456562tare_s
tarres64723042tarres
taters64932202taters
tawers94118602tawers
taxers134015282taxers
tearers75218232tearers
variers103712662variers
waders109120652waders
wafers124316152wafers
wagers105122212wagers
wakers134822502wakers
walers94824492walers
warders113416812warders
wares88250582ware_s
warmers124514292warmers
warners103315562warners
warpers123413582warpers
waters95030642waters
wavers125022482wavers
waxers164014312waxers
wearers104615902wearers
wirers94617892wirers
yagers105114532yagers
yarders113211592yarders
yarer84321572yarer_
yarners104312202yarners

Search took 4 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 Filter178691825510.373479064.3
2DLD Change Limit825512402.56332208.7
3Display Results2402400.0803000.0
 (SQL Overall)1786912403.01659247.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.