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

219 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
lanugo73557(None) 
lanugos834451lanugos
lang56637382lan_g_
langue71012172langue
languor895422languor
langur7109302langur
largo65319782la_rgo
latigo73410012latigo
laugh94414372la_ugh
lingo66022112lin_go
mango85724322man_go
tango66921172tan_go
aerugo735803aerugo
ago48845523_a__go
ajuga1335883_ajuga
alang66023513alan_g_
almug8429303almug_
almugs9396423almugs
alnico877943alnico
amigo86515473_amigo
ancho104515303_ancho
andro6314163_andro
anga56831353_an_ga
anglo65215373_anglo
anus47131113_anu_s
auto47432083_a_uto
banco94019393ban_co
bandog1038723bandog
bang74837003ban_g_
bangs85627773ban_gs
banjo143812443ban_jo
bingo86020093bin_go
bongo85720943bon_go
cangue91012443cangue
canso75019403can_so
canto74931013can_to
canula8312963canula
cargo85322073ca_rgo
clang86019313clan_g_
clangor10426683clan_gor
clangs95113613clan_gs
colugo935863colugo
congo85623133con_go
dago65725093da__go
dang65131543dan_g_
dangs75623203dan_gs
danio6319783dan_io
dingo74720793din_go
erugo6369853_erugo
fanega1055783fanega
fang85432553fan_g_
fanga96119623fan_ga
fangs96224073fan_gs
fano75831693fan__o
fanum10313443fanu_m
fanums1137263fanums
faugh125712963fa_ugh
flange103411973flan_ge
fungo94413133fun_go
galago838913galago
gang66031973gan_g_
gangs76222573gan_gs
gangue81310573gangue
gauge76117903ga_uge
ginkgo12334943ginkgo
hang85535553han_g_
hangs95726723han_gs
hangul1049213hangul
hangup1277293hangup
haugh125114053ha_ugh
jingo134615213jin_go
lacuna8118123lacuna
lacune8169673lacune
ladino73615123ladino
laevo849363la_evo
lag47862123la__g_
lags56546223la__gs
laguna7127223laguna
lagune7158633lagune
laigh95515923la_igh
lanai5319573lan_ai
lanais6316793lanais
lanate6421263lanate
lance75126723lan_ce
lanced93717723lanced
lancer84319973lancer
lances84824103lances
lancet84223573lancet
land56337313lan__d
landau7310613landau
landed84619243landed
lander74028483lander
lands65426903lan_ds
lane45153333lan__e
lanely93914483lanely
lanes54946793lan_es
language10105003language
langues81211913langues
languet8713693languet
languid936623languid
languors976153languors
langurs889103langurs
lank84734453lan__k
lanker104123003lanker
lankly13439623lankly
lanky125517483lan_ky
lanner64920603lanner
lanose6313593lanose
lapdog1034443lapdog
large65325463la_rge
largos74815063la_rgos
larum74317973laru_m
larums83610533larums
lasso55015683la_sso
latigos8277243latigos
latino64120473latino
latu47934183latu__
lauan55216793la_uan
laud56527723la_u_d
lauds65618483la_uds
laughs10489023la_ughs
launce8469183launce
launch11368063launch
laura54116203la_ura
lavabo1135273lavabo
lavage1038263lavage
layup1037723layu_p
layups1133993layups
lazuli1535363lazuli
leno47331393len__o
lentigo846063lentigo
lento57223393len_to
liang64914413lian_g_
liangs74410593lian_gs
linage7713403linage
ling57447963lin_g_
linga66820823lin_ga
lings67135773lin_gs
lingua7509913lingua
lingy96925143lin_gy
lino46343373lin__o
linum7313823linu_m
linums838283linums
linuron746513linuron
llano5910603llan__o
logo57931763l__ogo
long56933343lon_g_
longe66626463lon_ge
longs65527063lon_gs
lough95118483l_ough
lounge75211213lounge
loungy10476833loungy
lug46138063l__ug_
luge55531643l__uge
lugs55233523l__ugs
lung55732493lun_g_
lunge65323803lun_ge
lungi65516053lun_gi
lungs65223883lun_gs
lunula636173lunula
lunule638433lunule
maduro936983maduro
manage93818903manage
manege94113203manege
manga85026203man_ga
mange84930193man_ge
mangos94319333man_gos
mangy115021243man_gy
manito8518693manito
mano66536813man__o
manual8313463manual
manure8313653manure
manus75924933manu_s
menudo945793menudo
mongo810122413mon_go
mungo84916053mun_go
nonego737013nonego
olingo736933olin_go
pang75336293pan_g_
panga85323533pan_ga
pangs84628663pan_gs
panino8315683panino
panto76129413pan_to
pargo86723723pa_rgo
pengo84317593pen_go
pingo87122713pin_go
planula935773planula
quango1636493quan_go
rancho114310853rancho
rang56939163ran_g_
range64728413ran_ge
rangy95320383ran_gy
ranula6311813ranula
sago56332673sa__go
sang55441233san_g_
sanga66023793san_ga
sangh95517453san_gh
santo56227283san_to
sargo65424413sa_rgo
saugh95318403sa_ugh
slang66324023slan_g_
slangs75615343slan_gs
slangy105411393slan_gy
snug55218693_snug_
snugs64913023_snugs
tang56138673tan_g_
tanga64923693tan_ga
tangos74216303tan_gos
tangs65028343tan_gs
tangy94519933tan_gy
tanto55724943tan_to
tanuki1034913tanuki
tenuto648743tenuto
vang84926043van_g_
vangs96319583van_gs
wangun1037103wangun
waugh125411683wa_ugh
yang85626073yan_g_
yangs95618693yan_gs

Search took 7 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 Limit1127162195.78019501.0
3Display Results2192190.0633476.2
 (SQL Overall)1786912196.23328668.5
 
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.