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 “raiders” 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.

115 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
raiders8461514(None) 
aiders74524631_aiders
braiders114110571braiders
raider74318741raider_
railers74420661railers
raisers73617391raisers
riders74123901r_iders
abiders104011082abiders
adders84315702_adders
aider65431132_aider_
aides65336602_aide_s
aimers84621912_aimers
airers64922312_airers
aivers94822322_aivers
alders74218422_alders
arider74717742arider_
bailers94221352bailers
baiters94619302baiters
banders104324562banders
biders94822802_biders
braider105112992braider_
branders114313092branders
broiders114211192broiders
carders104820352carders
chiders135312942chiders
ciders94620092_ciders
daikers124010312daikers
danders93921182danders
drainers92811252drainers
eiders74321362_eiders
faders105117462fa_ders
gadders103611502gadders
gainers84214592gainers
gaiters83516542gaiters
ganders93521702ganders
gliders94811842gliders
graders94716012gra_ders
grainers93012072grainers
guiders94111112guiders
hailers104017262hailers
handers114224332handers
hiders104919652_hiders
jailers144114042jailers
kaisers11369272kaisers
ladders94115172ladders
laders74927762la_ders
landers84026212landers
larders83516942larders
lauders84012892lauders
madders113513212madders
maidens10349662maidens
mailers94420332mailers
maimers113813042maimers
nailers73215892nailers
padders113312872padders
panders103423732panders
praisers103410832praisers
racers84725432ra_cers
rackers134320452rackers
radars71314672ra_dars
rafters103715632rafters
raided85017702raide_d
raids65827512raid__s
railer64524932railer_
raiser66620102raiser_
raises64826542raise_s
rakers104123572ra_kers
rammers113715042rammers
rangers83621042rangers
rankers113217462rankers
ranters73323642ranters
rapers84327182ra_pers
rapider1067902rapider_
rapiers95012872rapiers
rappers113618442rappers
rasers64526782ra_sers
rashers104020912rashers
raspers94415922raspers
rasters74629022rasters
raters63936582ra_ters
ratters74422472ratters
ravers94628182ra_vers
razers154919612ra_zers
readers83823772readers
redders93615342redders
reivers105117082reivers
renders83821672renders
residers93311882residers
ricers84120992r_icers
ridders93612492ridders
rider65231302r_ider_
rides66140812r_ide_s
rimers84522552r_imers
risers64624782r_isers
rivers94626542r_ivers
rudders93210652rudders
ruiners74213022ruiners
sailers73822322sailers
sanders84025942sanders
sliders83515222sliders
spiders103914412spiders
tailers73720182tailers
traders84316952tra_ders
trailers82912922trailers
trainers83114642trainers
voiders11279822voiders
wadders123812442wadders
waders109120642wa_ders
wailers103916802wailers
waiters104218622waiters
waivers133410052waivers
wanders114221332wanders
warders113416812warders
yarders113211592yarders
zanders173015792zanders

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 Filter1786911076710.356501941.0
2DLD Change Limit1076711153.15634116.3
3Display Results1151150.0333484.8
 (SQL Overall)1786911153.54550406.5
 
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.