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

187 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
dugout831036(None) 
bugout9311861bugout
dugouts935041dugouts
bugouts1036192bugouts
burgout1049772burgout
buyout11310102buyout
cutout8315922cutout
devout10712992devout
dimout9414242dimout
dugong934372dugong
gout56646002__gout
pigout9314612pigout
putout8315112putout
ragout7317182ragout
rubout8313562rubout
rugous739652rugous
runout6414872runout
about75229083_about
agouti7388773_agouti
agouty10366913_agouty
argot67728653argo_t
aught95120703aug_ht
augur64311213aug_ur
august739203august
aurous64119263aurous
begot84625953bego_t
bigot84828323bigo_t
bout66353293__bout
burgouts1145123burgouts
burnout9310453burnout
butut75522913bu_tut
buyouts1235203buyouts
clout75330463_clout
copout10418783copout
cutouts938033cutouts
dacoit9415453dacoit
dago65725093dago__
dagoba1074943dagoba
dagoes85714603dagoes
dagos76419443dago_s
dakoit11310353dakoit
daut56443563d__aut
debut86024143d_ebut
decoct11313783decoct
degum94711903deg_um
degust8310253degust
dehort104618103dehort
demount1049743demount
deport94922393deport
depot85727923depo_t
detour778193detour
devour1076703devour
dicot85429093dico_t
digest84019623digest
dight104027003dig_ht
digit73825273dig_it
diglot83014333diglot
dimouts1037893dimouts
divot95723073divo_t
doat56947673d__oat
doit56347853d__oit
dolour75710133dolour
dolt56649423d__olt
donut6324513d_onut
dost57248353d__ost
dot47573183d__o_t
doubt8720093d__oubt
doughnut1343563doughnut
dought114915513doug_ht
doum76226673d__oum
dour56330433d__our
doux125817983d__oux
drogue8938333drogue
droit65127123d_roit
dropout10410003dropout
dropt86924433d_ropt
drouk1039433d_rouk
drouth104410103d_routh
drugget10337613drugget
dubious1036893dubious
ducat86225903du_cat
duct75735463du__ct
duet56446263du__et
dufus94010813du_fus
dug58138693dug___
dugongs1053253dugongs
dugs614832283dug__s
duit56241583du__it
dulcet9314493dulcet
dumdum1244523dumdum
dunt55746873du__nt
duo48536143du_o__
duomi8310133du_omi
duomo839753du_omo
duos56728133du_o_s
duro56228023duro__
duroc84513143duro_c
durocs9569703durocs
duros65422693duro_s
durst66125173du_rst
durum8513203du_rum
dust57142533du__st
dustup935363dustup
duteous838453duteous
duvet9321873du_vet
dyvour1393343dyvour
englut738453englut
ergot65422893ergo_t
fagot9323403fago_t
flout86226203_flout
fucous11399863fucous
fugu85419863fug_u_
fugue94313373fug_ue
fugus95914013fug_us
fungous11367433fungous
gigot74023073gigo_t
glout65925813_glout
glut56331293__glut
goat56250833__goat
got49870443__go_t
gouts64826173__gouts
gouty95217363__gouty
grout65330423_grout
guglet84018223guglet
gut46753853__g_ut
guyot9314523guyo_t
hagbut1278913hagbut
hangout11411393hangout
hognut1039413hognut
hugeous1137133hugeous
hugest10311763hugest
humour11116753humour
ingot61221063ingo_t
jugful1734603jugful
jugum15167473jug_um
knout95018263_knout
layout9513703layout
lout45952143__lout
lupous849433lupous
magot8326393mago_t
mahout11415803mahout
mucous104411653mucous
mugful1235403mugful
muggur10325593muggur
mugwort1346753mugwort
nugget8311723nugget
ought95221533oug_ht
out38072153___out
outjut13610063outjut
output8712853output
payout11714653payout
pignut9311573pignut
pigouts1037593pigouts
pout65752553__pout
pullout9310593pullout
putouts937083putouts
quoit143819863qu_oit
ragouts838543ragouts
redout71820253redout
rigour7258023rigour
rout46153283__rout
rubouts937983rubouts
rufous948273rufous
rugola736293rugola
rugosa734563rugosa
rugose737283rugose
rumour8127383rumour
runouts737353runouts
sagbut959753sagbut
scout75031453_scout
setout64719463setout
shout85433173_shout
shutout1048533shutout
snout54530633_snout
spout75029633_spout
sprout8419403sprout
stout57434053_stout
surtout7411673surtout
tout46753823__tout
trout57332573_trout
tryout9410753tryout
tugboat10126103tugboat
tumour8137403tumour
turnout7410283turnout
uncut73219173_uncut
ungot61718063ungo_t
vigour10256803vigour

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.1431249587.4
2DLD Change Limit1127161876.00018786.0
3Display Results1871870.0603116.7
 (SQL Overall)1786911876.20328807.2
 
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.