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

114 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
loaders8341343(None) 
laders74927761l_aders
leaders83819601leaders
loader74316311loader_
loafers10349461loafers
loaners73913621loaners
beaders104120182beaders
bladers104214682bladers
bloaters103311022bloaters
boarders11408622boarders
boaters93419242boaters
bonders104120662bonders
borders104317532borders
clowders14357472clowders
coalers94419352coalers
coaters93525792coaters
coaxers164311082coaxers
codders114114452codders
coders95426982co_ders
corders104520882corders
dodders105511792dodders
evaders1136932evaders
faders105117462_faders
floaters112711512floaters
flooders12257832flooders
foamers123812102foamers
fodders124010752fodders
folders113514392folders
gloaters9288862gloaters
graders94716012graders
headers113819392headers
hoarders12307432hoarders
hoaxers17327132hoaxers
holders113715902holders
laagers83411252laagers
lacers85225252l_acers
ladders94115172ladders
ladens74516232l_adens
lader65633722l_ader_
lades65141272l_ade_s
ladlers84613572l_adlers
lagers74826142l_agers
lakers105225152l_akers
landers84026212landers
larders83516942larders
lasers64925702l_asers
lauders84012892lauders
lavers94526362l_avers
layers93921182l_ayers
leadens83610982leadens
leader74824652leader_
leakers113415422leakers
leaners73718172leaners
leapers93716662leapers
leasers74717842leasers
leavers103717782leavers
lenders84419642lenders
loaded84616872loade_d
loads65323372load__s
loafer93610942loafer_
loaner64416502loaner_
loathers113310442loathers
loaves94813852loave_s
lobbers113713942lobbers
locaters102710072locaters
lockers133516922lockers
lodens74315062lo_dens
lodes66436912lo_de_s
lodgers95113832lodgers
lofters103912902lofters
loggers94616132loggers
loiters74116612loiters
lollers72713792lollers
loners64225812lo_ners
longers84819542longers
lookers114014072lookers
loopers93914032loopers
looters74419162looters
lopers84424142lo_pers
loppers113014102loppers
losers65123582lo_sers
lotters73921062lotters
loudens8368052loudens
louder74414602louder_
louvers10359102louvers
lovers94223432lo_vers
lowers94624922lo_wers
moaners92813552moaners
molders103315552molders
nodders94410262nodders
oaters65029792_oaters
orders74315992_orders
pleaders113210182pleaders
plodders1235522plodders
polders103617372polders
ponders103618842ponders
powders134111552powders
readers83823772readers
reloaders1036422reloaders
roadeos837412roadeos
roamers93713462roamers
roarers73812742roarers
shaders115915552shaders
soakers114114952soakers
soapers93715922soapers
soarers74118092soarers
solders83517772solders
sonders83820712sonders
spaders104214472spaders
traders84316952traders
unloaders1044402unloaders
voiders11279822voiders
waders109120642_waders
wonders113315992wonders

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.390458182.1
2DLD Change Limit1076711143.40631612.2
3Display Results1141140.0462478.3
 (SQL Overall)1786911143.84246509.9
 
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.