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 “lithia” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

235 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
lithia93933(None) 
lithias1038821lithias
lithic1139491lithic
lathi85417202lathi_
lathis95516172lathis
latria62313602latria
lichi104412952lichi_
lichis115212592lichis
litai55216362litai_
litchi1137892litchi_
litchis1238372litchis
lithe84922012lith_e
lithemia1345252lithemia
lither94520952lither
lithify1644762lithify
lithium1245822lithium
litho86513782lith_o
lithoid1148772lithoid
lithos94212552lithos
lochia1158312lochia
within123611382within
althea938213althea
asthma11126563asthma
atria56022343_atria
blithe115810863blith_e
blither124812173blither
bothria1246443bothria
chia96026623__chia
cilia73016763ci_lia
cithara12166513cithara
cither114616683cither
citola838393citola
citric102812313citric
citrin82615413citrin
clitic103315053clit_ic
clivia1177233cli_via
dita56032523dit__a
dither104417683dither
dithiol1145433dithiol
either94517423either
entia5318203ent_ia
eolithic1375853eolithic
ethic101511223_ethic
gittin72910553gittin
gothic1237793gothic
hither124417253hither
ilia46026823_i_lia
inia45024703_i_nia
ischia1136393ischia
ither84617603_ither
ixia115713213_i_xia
kishka1232963kishka
kith115826363kith__
kithara14145193kithara
kithe125917453kith_e
kithed144613013kithed
kithes135016653kithes
kithing153411553kithing
kiths125814973kith_s
labia75219013l_abia
laith85722103laith__
laithly1335653laithly
lamia75324323l_amia
latakia1146093latakia
lath76640383lath__
lathe85626723lath_e
lathed104718463lathed
lather95124363lather
lathes95127503lathes
lathier10310833lathier
lathing114315693lathing
laths86022403lath_s
lathy115215063lath_y
lati46438273lat_i_
latina65621143latina
latrias71913213latrias
lattin64316223lattin
lecithin1344313lecithin
lehua837953l_ehua
lethal939803lethal
lethe85717303leth_e
lethean1037093lethean
lethes94818083lethes
liana53915893li_ana
libra74712423li_bra
libri74610113libri_
lich96230843lich__
lichee114017973lichee
lichen114012743lichen
liches114724293liches
licht104723493lich_t
lichts113712383lichts
licit74327683li_cit
light94429603ligh_t
lights104519913lights
lignin74911193lignin
ligula7359673ligula
likuta1034213likuta
lima65734133li__ma
limba95414983li_mba
limbi96513813limbi_
limbic12528743limbic
limina83514503limina
limit73126343li_mit
limnic10418843limnic
limpa97014463li_mpa
limpid11389753limpid
linga66820823li_nga
lingua7509913lingua
linin58025523li_nin
lipa68425923li__pa
lipid85916173li_pid
lipin75518893li_pin
lipoid9411043lipoid
lipoma1046753lipoma
liquid1637143liquid
lira46928683li__ra
liri45128253li_ri_
listeria839433listeria
lit39377313lit___
litany939053litany
litas54923773lit_as
lite47054543lit__e
liter54736343lit_er
literal7613273literal
liters65429883liters
lithely1356643lithely
lithemias1445033lithemias
lithemic1545593lithemic
lithest10513913lithest
lithiases1244773lithiases
lithiasis1243593lithiasis
lithiums1344313lithiums
lithoed1137833lithoed
lithoidal1343753lithoidal
lithoing1236743lithoing
lithops12307253lithops
litmus836323litmus
litoral7610763litoral
litotic939243litotic
litre55421463lit_re
litres65220393litres
lits46252493lit__s
litten64014873litten
litter64324853litter
little63312163little
litu47631563lit__u
livid96714423li_vid
lixivia1743053lixivia
lochial1257083lochial
loggia8457053loggia
logia68116603l_ogia
lota47233503lot__a
loth76132133loth__
loti46431843lot_i_
lotic76420673lot_ic
lutea54819073lut_ea
lutein6311263lutein
luthier1038233luthier
lytic104513033lyt_ic
lytta888063lyt_ta
milia72719573mi_lia
militia949733milit_ia
mishit112618203mishit
mither114218563mither
mitis75425993mit_is
mythic1637273mythic
nihil8410283ni_hil
nitchie1247233nitchie
nitid61817833nit_id
nitric82512063nitric
nitrid72812233nitrid
nitril62511533nitril
nitwit938593nitwit
nutria639913nutria
ohia75719363__ohia
oidia6314953oi_dia
ostia52315583ost_ia
outhit92818473outhit
pita65436433pit__a
pitaya1186603pitaya
pith95432693pith__
pithead13419593pithead
pithed124615613pithed
pithier123010293pithier
pithily1567033pithily
pithing134014053pithing
piths105817543pith_s
pithy135614463pith_y
pitta75018693pit_ta
raphia113511263raphia
retia55326113ret_ia
rishi8311253rishi_
rishis9312453rishis
sith75435153sith__
slither104112983slither
stria55723213_stria
thin76732393__thin
thio77225413__thio
thir76420543__thir
this76027383__this
tibia7312403ti_bia
titania738293titania
titbit839823titbit
tithe85319703tith_e
tithed104115593tithed
tither94920283tither
tithes94720213tithes
tithing113513893tithing
tithonia1195613tithonia
titi47130623tit_i_
titian62512663tit_ian
titis56023813tit_is
tittie63213153tittie
vigia94813273vi_gia
vita75828523vit__a
vitric112510113vitric
vitta85015173vit_ta
wisha114910853wish_a
with105730473with__
withal1238933withal
withe115220233with_e
withed134416233withed
wither124321353wither
withes124620843withes
withier132910493withier
withies133913543withies
withing143814493withing
withins133511693withins
withy144813763with_y
yttria954803yttria
zinnia1536013zinnia
zither183813083zither
ziti136022373zit_i_
zitis145815583zit_is

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127162354.89023050.3
3Display Results2352350.0802937.5
 (SQL Overall)1786912355.36033337.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.