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 “loath” 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
loath8491860(None) 
lath76640381l_ath
loach105116361loach
loathe94211381loathe
lotah85315851lotah
loth76132131lo_th
oath76132151_oath
bath95940082_bath
bloat75229922bloat_
bloats85215762bloats
boat66360312boat_
boats75635152boats
booth105522012booth
both96533432bo_th
cloth105817542clo_th
coach125919452coach
coat67558352coat_
coati75624642coati
coats75635002coats
couth106122492couth
death94822522death
doat56947672doat_
doats65224882doats
doeth9411982doeth
doth86225712do_th
eath75735662_eath
float85928572float_
floats96816252floats
floaty124210942floaty
forth116222672forth
gloat65427682gloat_
gloats74515422gloats
goat56250832goat_
goats65527302goats
goth86825082go_th
hath105933912_hath
heath115724282heath
laith85722102laith
lakh114919952l_akh
lash76539652l_ash
lat37593402l_at_
latch104620462l_atch
late47560482l_ate
lathe85626712l_athe
lathi85417202l_athi
laths86022402l_aths
lathy115215062l_athy
lati46438272l_ati
lats45962702l_ats
latu47934182l_atu
leach105422522leach
leash85519212leash
load56730602loa_d
loads65323372loads
loaf76734902loa_f
loafs85616992loafs
loam65630482loa_m
loams75619862loams
loamy105913342loamy
loan47436452loa_n
loans56026462loans
loathed11419442loathed
loather103711002loather
loathes103513242loathes
loathly1334712loathly
lobate82915242lobate
locate83919842locate
loch95527132lo_ch
loft76539142loft_
lofts85518362lofts
lofty115813302lofty
loot46955822loot_
loots55431422loots
lost47951492lost_
lot38179262lo_t_
lota47233502lo_ta
lotahs9479872lotahs
lotas55926302lotas
loti46431842lo_ti
lots47652092lo_ts
lotte54923852lotte
lotto55217572lotto
lough95118482lough
lout45952142lout_
louts56330272louts
lovat8321042lovat_
lovats939072lovats
math95437452_math
moat66352032moat_
moats75827642moats
month104818422month
moth96731332mo_th
mouth105420292mouth
neath86020282neath
north86018272north
oat39888262_oat_
oaths86117312_oaths
oats46554212_oats
path99134912_path
poach124917862poach
rath76037662_rath
roach105717002roach
routh86423072routh
rowth115713232rowth
sloth85019452slo_th
snath86419802snath
sooth85924062sooth
soth75932522so_th
south85223572south
swath115920382swath
tooth88020182tooth
worth117120522worth
wrath115715872wrath
youth115315042youth

Search took 2 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.0931921408.6
2DLD Change Limit538001141.68631909.8
3Display Results1141140.0333454.5
 (SQL Overall)1786911141.81298615.3
 
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.