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

125 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
lithe8492201(None) 
blithe115810861blithe
kithe125917451kithe
lathe85626711lathe
lethe85717301lethe
lite47054541lit_e
lither94520951lither
litho86513781litho
litre55421461litre
tithe85319701tithe
withe115220231withe
bathe105822882bathe
bite66547002bit_e
blite76225352blit_e
blither124812172blither
cite65640342cit_e
cither114616682cither
cliche133712452cliche
clothe114712992clothe
dite55547552dit_e
dither104417682dither
either94517422either
elite56230182elit_e
fiche134616742fiche
flite85424962flit_e
gighe10139732gighe
gite55438612git_e
hither124417252hither
ither84617602_ither
kite85338232kit_e
kith115826352kith_
kithed144613012kithed
kithes135016652kithes
kiths125814972kiths
kythe15509672kythe
laith85722102laith_
late47560482lat_e
lath76640382lath_
lathed104718452lathed
lather95124352lather
lathes95127492lathes
lathi85417202lathi
laths86022402laths
lathy115215062lathy
latke94817092latke
latte55426302latte
lethes94818082lethes
liane54720662liane
lice66045062li_ce
lich96230842lich_
lichee114017972lichee
lichen114012742lichen
liches114724292liches
lichi104412952lichi
licht104723492licht
lie38264522li__e
liege65314432liege
lieve86315472lieve
life75433732li_fe
light94429602light
like86040842li_ke
lime66244932li_me
line46965572li_ne
lipe66839732li_pe
lire47845292li_re
lisle53916722lisle
listee64223062listee
lit39377312lit__
litai55216362litai
litas54923772litas
litchi1137892litchi
liter54736342liter
lithely1356642lithely
lithest10513912lithest
lithia939332lithia
lithic1139492lithic
lithoed1137832lithoed
lithos94212552lithos
litres65220392litres
lits46252492lit_s
litten64014872litten
litter64324852litter
little63312162little
litu47631562lit_u
live76540992li_ve
livre85613252livre
loathe94211382loathe
loth76132132loth_
lotte54923852lotte
lute46341012lut_e
miche126219242miche
mite66249412mit_e
mither114218562mither
mitre75522422mitre
niche105016792niche
nite45943582nit_e
nitre57519682nitre
pith95432692pith_
pithed124615612pithed
piths105817542piths
pithy135614462pithy
rathe85821922rathe
rite45849452rit_e
saithe94713912saithe
sidhe95315102sidhe
site47052412sit_e
sith75435152sith_
slither104112982slither
swithe124010682swithe
the67436052__the
tithed104115592tithed
tither94920282tither
tithes94720212tithes
title54721072title
titre54619392titre
tythe115210452tythe
vitae84217632vitae
wite75443272wit_e
with105730472with_
withed134416232withed
wither124321352wither
withes124620842withes
withy144813762withy
writhe125310702writhe
zither183813082zither

Search took 3 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.1231452772.4
2DLD Change Limit538001252.01626686.5
3Display Results1251250.0333787.9
 (SQL Overall)1786911252.17282270.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.