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

102 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
outtower113619(None) 
outpower1336671outpower
outtowers1244761outtowers
buttoner1036972buttoner
outdoer849272outdo_er
outhomer1348132outhomer
outpowers1445192outpowers
outrowed1239432outrowed
outtowered1442762outtowered
bestower13126203bestower
bottomer1245103bottomer
burrower1374263burrower
butter84724233butt__er
buttoned1137503buttoned
buttoners1145703buttoners
customer1245383customer
cutover1235283cu_tover
cutter84521003cutt__er
furrower1464033furrower
gutter73817713gutt__er
guttier83911103gutt_ier
guttler8369163gutt_ler
kotower1434383_kotower
kowtower1842273kowtower
mutter84418883mutt__er
mutterer10218913mutterer
nutter63918053nutt__er
nuttier73112023nutt_ier
otter54423973o_tt__er
ouster64223733oust__er
outboxed1836873outboxed
outboxes1737823outboxes
outcaper1246873outcaper
outcome11310573outcome_
outcomes1239763outcomes
outcrowed1555873outcrowed
outdoers937513outdo_ers
outdoes8313123outdo_es
outdone8311643outdone_
outdoor836713outdo_or
outer55633303ou_t__er
outerwear1242573outerwear
outflowed1665063outflowed
outfoxed1936013outfoxed
outfoxes1836743outfoxes
outglowed1444313outglowed
outgoes8312643outgo_es
outgone8311463outgone_
outhomers1446063outhomers
outhowl1337203outhow_l
outhowled1645103outhowled
outhowls1445723outhowls
outlawed1238033outlawed
outlier72216143ou_tlier
outliner82412113outliner
outliver11268783outliver
outlove102410243outlove_
outloved12248583outloved
outloves11249673outloves
outmode10199663outmode_
outmoded12207703outmoded
outmodes11208963outmodes
outmove12238713outmove_
outmoved14247283outmoved
outmoves13228173outmoves
outpour937423outpo_ur
outpourer1144163outpourer
outpowered1643003outpowered
outrider92410563outrider
outroar739513outro_ar
outrode82313423outrode_
outrow9311183outrow__
outrows10311403outrow_s
outsider9269643outsider
outsoar739493outso_ar
outsole71013433outsole_
outsoles8813113outsoles
outsteer837553outsteer
outswear1144793ou_tswear
outswore11168673outswore
outtake11310793outtake_
outtakes12310033outtakes
outthrew14123973outthrew
outtold8107603outto_ld
outtowering1542853outtowering
outvote1038803outvote_
outvoted1237273outvoted
outvotes1137903outvotes
outwar91011513ou_t_war
outwear1097713ou_t_wear
outwore101912693outwore_
outworker1644683outworker
putter83921443putt__er
putterer10209913putterer
puttier93314503putt_ier
ruttier73412283rutt_ier
tattooer844373tattooer
tower85729203___tower
tutoyer1033793tu_toyer
uptowner1342043_uptowner
utter54218763_utt__er
utterer71910463_utterer

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621027.15620425.1
3Display Results1021020.0462217.4
 (SQL Overall)1786911027.60823487.3
 
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.