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

246 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
quango163649(None) 
quangos1734651quangos
fungo94413132fu_ngo
guano69213982guan_o
mango85724322_mango
mungo84916052mu_ngo
quag144815942qua_g_
quagga1754142quagga
quaggy2084682quaggy
quags154613252qua_gs
quahog1944102quahog
quaigh1935462quaigh
quant143624812quan_t
quanta153911332quanta
quants153614142quants
quarto153511122quarto
tango66921172_tango
ago48845523__a_go
alang66023513alang_
anga56831353__anga
anglo65215373__anglo
banco94019393_banco
bang74837003_bang_
bangs85627773_bangs
banjo143812443_banjo
beano75421553bean_o
bhang115512923bhang_
bhangs12449663bhangs
bingo86020093_bingo
bongo85720943_bongo
bunco94616083bu_nco
bung75730633bu_ng_
bungs85323863bu_ngs
bunko115514513bu_nko
canso75019403_canso
canto74931013_canto
cargo85322073_cargo
chang115418563chang_
change124116753change
changs125215373changs
clang86019313clang_
clangor10426683clangor
clangs95113613clangs
congo85623133_congo
cuatro838433cuatro
cuing85420193cuing_
cyano105512493cyan_o
dago65725093_da_go
dang65131543_dang_
dangs75623203_dangs
danio6319783_danio
dingo74720793_dingo
drongo836793drongo
dung66328433du_ng_
dungs75821973du_ngs
dungy104713643du_ngy
eringo739553eringo
eryngo1033613eryngo
fang85432553_fang_
fanga96119623_fanga
fangs96224073_fangs
fano75831693_fan_o
flange103411973flange
fungi95014133fu_ngi
gang66031973_gang_
gangs76222573_gangs
grange83716203grange
gringo838643gringo
guaco85012163gua_co
guan55325583guan__
guanaco1064583guanaco
guanay1037913guanay
guanin7610803guanin
guanos73811993guanos
guans64419443guan_s
hang85535553_hang_
hangs95726723_hangs
hung86126353hu_ng_
imago8118693ima_go
jingo134615213_jingo
junco144612203ju_nco
junto125114563ju_nto
kiang104811353kiang_
kiangs11378363kiangs
lang56637383_lang_
lanugo735573_lanugo
largo65319783_largo
liang64914413liang_
liangs74410593liangs
lingo66022113_lingo
llano5910603llan_o
lung55732493lu_ng_
lunge65323803lu_nge
lungi65516053lu_ngi
lungs65223883lu_ngs
manga85026203_manga
mange84930193_mange
mangos94319333_mangos
mangy115021243_mangy
mano66536813_man_o
mongo810122413_mongo
mungos94311373mu_ngos
nuance859043nuance
olingo736933olingo
orang65119943orang_
orange74016323orange
orangs74116033orangs
orangy105111233orangy
ourang73311063ourang_
ourangs8318503ourangs
outgo6312093ou_tgo
pang75336293_pang_
panga85323533_panga
pangs84628663_pangs
panto76129413_panto
pargo86723723_pargo
pengo84317593_pengo
piano76118713pian_o
pingo87122713_pingo
prang84820323prang_
prangs94816233prangs
pung75429633pu_ng_
pungs85422223pu_ngs
punto75121323pu_nto
qanat144426843q_anat
qua124821973qua___
quack203812503qua_ck
quacks214710103quacks
quacky24376963quacky
quad144618703qua__d
quads154515843qua_ds
quaere154110673quaere
quaff201311353qua_ff
quaffs21125693quaffs
quaggas1893703quaggas
quahogs2043163quahogs
quai134420393qua__i
quaich2047693quaich
quaighs2043493quaighs
quail144314363qua_il
quails153412643quails
quaint15415173quaint
quais144618393qua_is
quake184114643qua_ke
quaked203910033quaked
quaker193811623quaker
quakes194013343quakes
quaking2139313quaking_
quaky214310743qua_ky
quale143617853qua_le
qualia1559563qualia
qualm163511183qua_lm
qualms17317243qualms
qualmy20285803qualmy
quandong1942943quandong
quantal16367893quantal
quanted1738963quanted
quantic18279063quantic
quantong1843493quantong
quantum1845103quantum
quare143920543qua_re
quark184614123qua_rk
quarks193810913quarks
quarry1837473quarry
quart144027853qua_rt
quarte154115323quarte
quartos16328733quartos
quarts154715933quarts
quartz244212103quartz
quasar1536833quasar
quash174512163qua_sh
quasi144015023qua_si
quass144413763qua_ss
quate144521413qua_te
quatre153512353quatre
quaver18309313quaver
quay164618353qua__y
quayage2044573quayage
quays174612043qua_ys
quean143612843quean__
queans153110753quean_s
quench2036633quench
quin135823923quin__
quince173910133quince
quinic17319473quinic
quinin152811953quinin
quinoa15377653quinoa
quinol15357973quinol
quins144819853quin_s
quinsy18386353quinsy
quint144529903quin_t
quinta153312373quinta
quinte153414523quinte
quints154316563quints
quohog1942503quohog
rang56939163_rang_
range64728413_range
rangy95320383_rangy
ruana5312423ruan_a
ruanas6311263ruanas
rubigo935053rubigo
ruing67221053ruing_
rung56429983ru_ng_
rungs611819403ru_ngs
sago56332673_sa_go
sang55441233_sang_
sanga66023793_sanga
sangh95517453_sangh
santo56227283_santo
sargo65424413_sargo
slang66324023slang_
slangs75615343slangs
slangy105411393slangy
spang84919733spang_
stang66424683stang_
stangs75018163stangs
stingo74212163stingo
suing65026363suing_
sung55832173su_ng_
swang95519723swang_
tang56138673_tang_
tanga64923693_tanga
tangos74216303_tangos
tangs65028343_tangs
tangy94519933_tangy
tanto55724943_tanto
tung55328163tu_ng_
tungs65520623tu_ngs
twang94511853twang_
twangs10358093twangs
twangy13386983twangy
unco66021403_u_nco
undo55620153_u_ndo
ungot61718063_u_ngot
unto45824283_u_nto
vang84926043_vang_
vangs96319583_vangs
vulgo936953vu_lgo
whang124813383whang_
whangs13439723whangs
wrang94716113wrang_
wrangs104611913wrangs
yang85626073_yang_
yangs95618693_yangs
yuan76120013yuan__
yuans84613323yuan_s

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.403443402.0
2DLD Change Limit1127162465.45620659.1
3Display Results2462460.0763236.8
 (SQL Overall)1786912465.93530108.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.