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

203 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
guidons93662(None) 
guidon837371guidon_
gipons9389602g_ipons
girons75014372g_irons
grisons838992grisons
guenons836562guenons
guerdons1044232guerdons
gueridons1142802gueridons
guiders94111112guiders
guides84118282guid_es
guiding102911842guiding
guids75516152guid__s
guiros7389092guiro_s
guldens9356572guldens
gundogs1034602gundogs
udons65411462_u_dons
amidins103713103amidins
amidols10457563amidols
amidone10349313amidone
amidones11348663amidones
anions64123033ani_ons
audios72312283audio_s
avidins11349003avidins
avions94114393avi_ons
axions134713483axi_ons
bisons83914373_bisons
bourdons1136433bourdons
bridoons1145423bridoons
bunions92210473bunions
burdens1039713burdens
burtons9310853burtons
buttons9310333buttons
cardons104519933cardons
chitons122611913chitons
cions75222853_ci_ons
codons96119463_codons
cordons104415763cordons
cutdowns1443343cutdowns
daikons12186693daikons
daimons10249323daimons
didoes85716963_didoes
didos76820813_dido_s
diurons838823diurons
dons56048703___dons
durions839963durions
eidos65817753_eido_s
eikons1038503_eikons
epigons1048183epigons
fidos95819053_fido_s
foisons1047613foisons
fusions1039153fusions
futons93911513fu_tons
gabions102410053gabions
gaboons10289903gaboons
gains65729513gai__ns
gallons83015953gallons
gammons1237973gammons
garcons102411643garcons
gardens93312093gardens
garrons82713463garrons
gascons10289103gascons
gibbons1234983gibbons
gibsons1045043gibsons
gids65933733g_id__s
gigots83911953g_igots
gins55543953g_i__ns
gipon84212413g_ipon_
girns64516803g_i_rns
giron66118993g_iron_
giros65722653g_iro_s
givens10379733g_ivens
gliadins1035193gliadins
gliders94811843gliders
glides84518863glid_es
gliding103911843gliding
gluons738503g_luons
gluttons944273gluttons
gnomons1035753gnomons
godowns1234673g_odowns
godsons966663godsons
goons65326773g__oons
gorgons938853gorgons
gradins93416233gradins
grides84422363grid_es
griding103014973griding
gridirons1162573gridirons
grids75321393grid__s
griffons1542573griffons
grins65427223gri__ns
griots74713643gri_ots
grison7310103grison_
grunions945353grunions
guacos94410313guaco_s
guanidins1143663guanidins
guanins8810013guanins
guanos73811993guano_s
guans64419443gu__ans
gudes74520813gu_d_es
gudgeons11113943gudgeons
guenon736403guenon_
guerdon944343guerdon_
gueridon1043033gueridon_
guid66022823guid___
guidance1244983guidance
guidances1344773guidances
guide75019883guid__e
guided94014113guid_ed
guider84313523guid_er
guilders1035513guilders
guilds8388353gui_lds
guiles73919283gui_les
guiling93214213guiling
guilts74111233gui_lts
guimpes1245073guimpes
guineas836753guineas
guiro63712093guiro__
guises74216313gui_ses
guising93511413guising
guitars8116863guitars
gulden8328763gulden_
gumbos114610873gumbo_s
gumdrops1442823gumdrops
gummous1236263gummous
gundog935793gundo_g
guns55533483gu___ns
gustoes879873gustoes
guyots1036003gu_yots
gyrons105511223g_yrons
hagdons1258523hagdons
hoidens11329083hoidens
humidors1443993humidors
icons76516493__icons
idols65514133__idols
ikons96311013__ikons
inions64417003ini_ons
ions46737853__i_ons
irons55324133__irons
judos134711733ju_do_s
jupons15377803ju_pons
kudos105011253ku_do_s
lardons83914493lardons
lidos65219883_lido_s
lions55923213_li_ons
lurdans837073lurdans
maidens10349663maidens
muons75816173mu__ons
mutons84314363mu_tons
muttons949283muttons
ninons64913773_ninons
nitons64614903_nitons
onions64016433oni_ons
orisons7310563orisons
outdoes8313123outdoes
outdone8311643outdone
pardons103817623pardons
pinons86019943_pinons
pions75826393_pi_ons
pitons85319043_pitons
poisons9310353poisons
prions84317783pri_ons
prisons9313223prisons
putdowns1443523putdowns
putons83515153pu_tons
quids154917463quid__s
quinins162811293quinins
quinoas16337873quinoas
quinols16297243quinols
quinone16217463quinone
quinones17227753quinones
quins144819853qui__ns
radons74118533_radons
redons75222183_redons
rubdowns1473083rubdowns
ruinous739763ruinous
ruins55822033rui__ns
rundowns1284533rundowns
scions82612243sci_ons
skidoos1234463skidoos
suddens9308783suddens
sudors7311103su_dors
suitors73012493suitors
suldans8299723suldans
summons1158003summons
sundogs947103sundogs
sundowns1285433sundowns
tendons8311473tendons
tigons74112263_tigons
trigons84312093trigons
tritons73814883tritons
tuitions838283tuitions
turions7311573turions
turnons737863turnons
udon56017743_u_don_
udos56619903_u_do_s
undoes73917403_undoes
undone7914253_undone
unions64216753_unions
unisons748423unisons
updos8389513_updo_s
voudons1135323voudons
widens106212723_widens
widows1376563_widows
yupons11398353yu_pons

Search took 8 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272036.81019680.9
3Display Results2032030.0633222.2
 (SQL Overall)1786912037.02925422.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.