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

237 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
guidon83737(None) 
guidons936621guidons
gipon84212412g_ipon
giron66118992g_iron
grison7310102grison
guenon736402guenon
guerdon944342guerdon
gueridon1043032gueridon
guid66022822guid__
guide75019882guid_e
guided94014112guided
guider84313522guider
guides84118282guides
guiding102911842guiding
guids75516152guid_s
guiro63712092guiro_
guiros7389092guiros
gulden8328762gulden
gundog935792gundog
udon56017742_u_don
amidin94015673amidin
amido85720983amido_
amidol9489573amidol
amidone10349313amidone
anion55028813ani_on
audio62917103audio_
audios72312283audios
avidin103510843avidin
avion84218343avi_on
axion1211316913axi_on
azido155411543azido_
bison75716983_bison
bourdon1036423bourdon
bridoon1046203bridoon
bunion83111313bunion
burden9412473burden
burton8311273burton
button8310273button
cardon94120853cardon
chiton112612393chiton
cion613330913_ci_on
codon86522853_codon
cordon95017293cordon
cutdown1344083cutdown
daikon11217243daikon
daimon9259713daimon
dido66528203_dido_
didos76820813_didos
diuron738573diuron
don46757653___don
durion7510963durion
eidos65817753_eidos
eikon939463_eikon
epigon937963epigon
fido87726403_fido_
fidos95819053_fidos
foison948933foison
fusion939773fusion
futon83113773fu_ton
gabion93211033gabion
gaboon93211773gaboon
gaijin1445983gaijin
gain56042163gai__n
gallon73715813gallon
gammon1138903gammon
garcon92912483garcon
garden84215083garden
garron73113493garron
gascon9339723gascon
gibbon1135323gibbon
gibson935123gibson
gid57047273g_id__
giddy115810203g_iddy
gids65933743g_id_s
gien56330023g_i_en
gigot74023073g_igot
gin46055753g_i__n
gipons9389603g_ipons
girn56026863g_i_rn
giro55828633g_iro_
girons75014373g_irons
giros65722653g_iros
given95915283g_iven
gliadin935593gliadin
glide74521593glid_e
glided94513903glided
glider84614263glider
glides84518863glides
gliding103911843gliding
gluon6311223g_luon
glutton844893glutton
gnomon936183gnomon
godown1136033g_odown
godson857383godson
golden84411153golden
gonion73612833gonion
goon57236173g__oon
gorgon8310243gorgon
gradin83517483gradin
grid65829613grid__
gride75223583grid_e
grided95117043grided
grides84422363grides
griding103014973griding
gridiron1072513gridiron
grids75321393grid_s
griffon1443103griffon
grin55733723gri__n
griot65328413gri_ot
grisons838993grisons
grunion835433grunion
guaco85012163guaco_
guacos94410313guacos
guan55325583gu__an
guanidin1044193guanidin
guanin7610803guanin
guano69213983guano_
guanos73811993guanos
gude65423333gu_d_e
gudes74520813gu_des
gudgeon10123743gudgeon
guenons836563guenons
guerdons1044233guerdons
gueridons1142803gueridons
guidance1244983guidance
guiders94111113guiders
guild75312753gui_ld
guilder945913guilder
guilds8388353guilds
guile64521133gui_le
guiled84315383guiled
guiles73919283guiles
guiling93214213guiling
guilt65125573gui_lt
guilts74111233guilts
guilty10418233guilty
guimpe1134723guimpe
guinea737613guinea
guise64717713gui_se
guised84612173guised
guises74216313guises
guising93511413guising
guitar7117443guitar
guldens9356573guldens
gumbo104413583gumbo_
gumbos114610873gumbos
gumdrop1342513gumdrop
gun47240803gu___n
gundogs1034603gundogs
gunman9299453gunman
gunmen9348723gunmen
gunnen7338713gunnen
gusto65414643gusto_
guyot9314523gu_yot
gyron95314623g_yron
hagdon1188283hagdon
hoiden103612333hoiden
humidor1343533humidor
icon66922043__icon
idol56818633__idol
ikon85814953__ikon
imido85812243imido_
inion54620183ini_on
ion36051023__i_on
iron46728463__iron
judo125315303ju_do_
judos134711733ju_dos
jupon14479193ju_pon
kudo96115113ku_do_
kudos105011253ku_dos
lardon74415063lardon
lido56028163_lido_
lidos65219883_lidos
lion46334443_li_on
lurdan738363lurdan
maiden93512283maiden
muon65722733mu__on
muton73817003mu_ton
mutton8510453mutton
ninon55517383_ninon
niton55418283_niton
onion54320973oni_on
orison6411663orison
outdo6312703outdo_
outdone8311643outdone
pardon94618733pardon
pinon76024533_pinon
pion67235293_pi_on
piton76121583_piton
poison8312223poison
prion75119993pri_on
prison8514023prison
putdown1343883putdown
puton73617913pu_ton
quid144922353quid__
quids154917463quid_s
quin135823923qui__n
quinin152811953quinin
quinoa15377653quinoa
quinol15357973quinol
quinone16217463quinone
radon64620503_radon
redon65424883_redon
rubdown1383893rubdown
ruin47430513rui__n
rundown1165443rundown
scion72214993sci_on
skidoo1136093skidoo
sudden83310833sudden
sudor6312623su_dor
suitor63311053suitor
suldan72611043suldan
summon1037623summon
sundog837613sundog
sundown1186313sundown
tendon7312033tendon
tigon63914443_tigon
trigon74513103trigon
triton63914893triton
tuition738823tuition
turion6313163turion
turnon638193turnon
udo49027303_u_do_
udons65411463_u_dons
udos56619903_u_dos
undo55620153_undo_
undone7914253_undone
union54519793_union
unison649033unison
unwon84512343_unwon
updo76712883_updo_
updos8389513_updos
upon65817583_u_pon
voudon1035873voudon
widen94717973_widen
widow1278933_widow
yupon10469483yu_pon

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.423422437.4
2DLD Change Limit1127162375.40620850.2
3Display Results2372370.0763118.4
 (SQL Overall)1786912375.90530261.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.