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

138 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
outfoot1041149(None) 
outfool1037331outfool
outfoots1136881outfoots
outroot7516561outroot
hotfoot1347052hotfoot
outcook1337202outcook
outdoor836712outdoor
outfast101412122outfast
outfelt10310602outfelt
outfit93014952outf_it
outfloat1146242outfloat
outflow1355352outflow
outfools1136532outfools
outfooted1345892outfooted
outfox1636142outf_ox
outlook1138022outlook
outmost9511212outmost
outplot9109482outplot
outport9714122outport
outpost9612442outpost
outroots839872outroots
outshoot1149162outshoot
outshot10312102outshot
outtrot7312612outtrot
afoot8420113__afoot
bigfoot1355993bigfoot
buffoon1543713buffoon
clubfoot1553033clubfoot
coltsfoot1452863coltsfoot
cutout8315923cut_out
finfoot1347173finfoot
flatfoot1445293flatfoot
foot76248013___foot
forefoot1448153forefoot
gumboot1246493gumboot
hotfoots1444323hotfoots
nutwood1144953nutwood
outact8317203out_act
outbloom1244003outbloom
outboast1048543outboast
outbox1537463out_box
outcast91013743outcast
outcome11310573outcome
outcooks1436723outcooks
outcount1049143outcount
outcrop1146773outcrop
outcrow1246343outcrow
outdo6312703out_do_
outdoer849273outdoer
outdoes8313123outdoes
outdone8311643outdone
outdoors936433outdoors
outdrop1036193outdrop
outeat62824533out_eat
outface123011973outface
outfall1039683outfall
outfasts11117233outfasts
outfawn1335983outfawn
outfeast11107503outfeast
outfeel1037543outfeel
outfight1546103outfight
outfind1139563outfind
outfire1049713outfire
outfish132210573outfish
outfits102210833outfits
outflew1336423outflew
outfloats1243573outfloats
outflown1464063outflown
outflows1445463outflows
outfly1238273outf_ly
outfooled1345493outfooled
outfooting1445653outfooting
outfought1643753outfought
outfound1245763outfound
outfoxed1936013outfoxed
outfoxes1836743outfoxes
outfrown1444863outfrown
outglow1154863outglow
outgo6312093out_go_
outgoes8312643outgoes
outgone8311463outgone
outgrow1136323outgrow
outhit92818473out_hit
outhowl1337203outhowl
outhunt10311043outhunt
outjut13610073out_jut
outkept1337883outkept
outlast71015443outlast
outlet63728683out_let
outlooks1236793outlooks
outlove102410243outlove
outmode10199663outmode
outmove12238713outmove
outplod10106343outplod
outplots1086363outplots
outpoint10311513outpoint
outpoll946793outpoll
outports1048273outports
outposts1037253outposts
outpour937423outpour
output8712853out_put
outquote1775293outquote
outroar739513outroar
outrock1339303outrock
outrode82313423outrode
outroll749303outroll
outrooted1047623outrooted
outrow9311183out_row
outrows10311403outrows
outsat62920283out_sat
outscoop1243993outscoop
outsert72819513outsert
outset64027453out_set
outshoots1245393outshoots
outshout1149493outshout
outsit63620893out_sit
outsoar739493outsoar
outsold8109073outsold
outsole71013433outsole
outstood945933outstood
outtold8107603outtold
outtrots838373outtrots
outvote1038803outvote
outwait10411763outwait
outwent10311363outwent
outwept1237933outwept
outwit93014593out_wit
outwore101912693outwore
outwork141710353outwork
outworn101610753outworn
outwrit10411423outwrit
outwrote1137723outwrote
putout8315113put_out
toot45958883__t_oot
unroot6315553_unroot
uproot8314123_uproot
utmost878483_utmost
webfoot1544213webfoot

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271385.89022755.0
3Display Results1381380.0632190.5
 (SQL Overall)1786911386.34328171.4
 
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.