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

184 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
lofts8551836(None) 
lefts86517811lefts
lifts85719061lifts
loft76539141loft_
lofty115813301lofty
loots55431421loots
lots47652091lo_ts
louts56330271louts
softs85019231softs
tofts84919241tofts
aloft8423432aloft_
bloats85215762bloats
blots75626172blo_ts
boats75635152boats
boffs134915502boffs
bolts76232112bolts
boots75837972boots
borts76735452borts
bots66453952bo_ts
botts75224862botts
bouts75131312bouts
clefts114610162clefts
clifts11519152clifts
cloots85113692cloots
clots75627642clo_ts
clouts87017202clouts
coats75635002coats
coffs134916302coffs
coft97939682coft_
colts76633292colts
coots75636842coots
costs77231142costs
cots68054842co_ts
crofts114910592crofts
doats65224882doats
doffs125614332doffs
doits66223672doits
dolts65626312dolts
dots55647662do_ts
efts76519482_efts
floats96816252floats
flouts94315272flouts
fonts86124752fonts
foots85528282foots
forts86034452forts
gifts96214962gifts
gloats74515422gloats
glosts74513812glosts
glouts74414712glouts
goats65527302goats
gouts64826172gouts
hafts116219462hafts
hefts116218152hefts
holts85627912holts
hoots84830252hoots
hosts85526702hosts
hots78349332ho_ts
jolts125018882jolts
jots116336142jo_ts
lasts57731262lasts
lats45962702l_ats
leets54927122leets
left76340482left_
lefty115613562lefty
lets47147942l_ets
lift76942722lift_
lilts55822802lilts
lints57137192lints
lists56628692lists
lits46252492l_its
loads65323372loads
loafs85616992loafs
loams75619862loams
loans56026462loans
loath84918602loath
lobes75331002lobes
lobos75921842lobos
lobs66441082lo_bs
lochs106715512lochs
locks115126922locks
locos75822602locos
locus74819992locus
lodes66436912lodes
loess55714702loess
lofted103811892lofted
lofter94614722lofter
lofters103912902lofters
loges66534202loges
logos67225332logos
logs57343112lo_gs
loids66220702loids
loins56728422loins
lolls512121732lolls
longs65527062longs
loofas9429832loofas
loofs85623782loofs
looks95124862looks
looms75124642looms
loons55731722loons
loops75723962loops
loos49051122lo_os
loot46955822loot_
lopes76437342lopes
lops66043352lo_ps
lords64923502lords
lores55045402lores
loris55329152loris
loses56742012loses
loss45337962lo_ss
lost47951492lost_
lot38179262lo_t_
lota47233502lo_ta
lotas55926302lotas
loth76132132lo_th
loti46431842lo_ti
lotos54724632lotos
lotte54923852lotte
lottes65322752lottes
lotto55217572lotto
lottos64613102lottos
lotus55718062lotus
louis57322322louis
loups75319622loups
lours55125292lours
lout45952142lout_
lovats939072lovats
loves85332012loves
lowes85732462lowes
lows75843012lo_ws
loxes125227472loxes
luffs114516282luffs
lunts55826902lunts
lusts55022802lusts
moats75827642moats
molts76032092molts
moots75831662moots
morts75533562morts
mosts76028542mosts
mots66853162mo_ts
motts76527002motts
nowts86915862nowts
oats46554212_oats
offs107117012_offs
oft67744062_oft_
oots46446442_oots
opts68124742_opts
orts46538332_orts
outs45746962_outs
plots75025672plo_ts
poets76024442poets
ports75934592ports
posts75228782posts
pots66452362po_ts
pouts75530322pouts
rafts87820632rafts
rifts85718642rifts
roots55933672roots
rots46454092ro_ts
routs57133412routs
sifts84918922sifts
slots54830532slo_ts
sofas85320712sofas
soft76942822soft_
softa86415182softa
softas94410402softas
softy115414482softy
soots55536212soots
sorts54536662sorts
sots45552452so_ts
toffs116016722toffs
toft77441652toft_
tofus86415422tofus
toits55327472toits
toots55331872toots
torts56138122torts
tots46654122to_ts
touts54830392touts
tufts85713272tufts
volts85421292volts
wafts116920552wafts
wefts116715492wefts
wonts87621542wonts
worts88631182worts
wots76342892wo_ts

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 Filter178691538000.640279204.7
2DLD Change Limit538001843.19016865.2
3Display Results1841840.1101672.7
 (SQL Overall)1786911843.94045353.0
 
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.