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

117 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
outfool103733(None) 
outfools1136531outfools
outfoot10411491outfoot
outcook1337202outcook
outdoor836712outdoor
outfall1039682outfall
outfeel1037542outfeel
outflow1355352outflow
outfooled1345492outfooled
outfoots1136882outfoots
outfox1636142outf_ox
outhowl1337202outhowl
outlook1138022outlook
outpoll946792outpoll
outroll749302outroll
outroot7516562outroot
batfowl1543593batfowl
befool1137713_befool
buffoon1543713buffoon
butanol945433butanol
fool75330593___fool
hotfoot1347053hotfoot
jetfoil1742913jetfoil
nutwood1144953nutwood
octanol944743octanol
outbawl1237473outbawl
outbloom1244003outbloom
outbox1537463out_box
outcall9310123outcall
outcome11310573outcome
outcooks1436723outcooks
outcrop1146773outcrop
outcrow1246343outcrow
outdo6312703out_do_
outdoer849273outdoer
outdoes8313123outdoes
outdone8311643outdone
outdoors936433outdoors
outdrop1036193outdrop
outduel837303outduel
outfable1378813outfable
outface123011973outface
outfalls1138143outfalls
outfast101412123outfast
outfawn1335983outfawn
outfeels1135063outfeels
outfelt10310603outfelt
outfield1265253outfield
outfind1139563outfind
outfire1049713outfire
outfish132210573outfish
outfit93014953outf_it
outfits102210833outfits
outflew1336423outflew
outfloat1146243outfloat
outflown1464063outflown
outflows1445463outflows
outfly1238273outf_ly
outfooling1445473outfooling
outfooted1345893outfooted
outfound1245763outfound
outfoxed1936013outfoxed
outfoxes1836743outfoxes
outfrown1444863outfrown
outglow1154863outglow
outgo6312093out_go_
outgoes8312643outgoes
outgone8311463outgone
outgrow1136323outgrow
outhaul1039063outhaul
outhowls1445723outhowls
outkill1136553outkill
outlooks1236793outlooks
outlove102410243outlove
outmode10199663outmode
outmost9511213outmost
outmove12238713outmove
outplod10106343outplod
outplot9109483outplot
outpolls1046213outpolls
outport9714123outport
outpost9612443outpost
outpour937423outpour
outpull956443outpull
outroar739513outroar
outrock1339303outrock
outrode82313423outrode
outrolls847823outrolls
outroots839873outroots
outrow9311183out_row
outrows10311403outrows
outsail71411413outsail
outscold11115253outscold
outscoop1243993outscoop
outsell7109263outsell
outshoot1149163outshoot
outshot10312103outshot
outsoar739493outsoar
outsold8109073outsold
outsole71013433outsole
outstood945933outstood
outtell797883outtell
outtold8107603outtold
outtrot7312613outtrot
outvote1038803outvote
outwill1037323outwill
outwore101912693outwore
outwork141710353outwork
outworn101610753outworn
outyell1095843outyell
poutful1236743poutf_ul
retool63914483ret_ool
stool55619893_st_ool
subcool1146233subcool
tomfool1254243tomfool
tool46735683__t_ool
uncool8610113_uncool

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.436409841.7
2DLD Change Limit1340271177.14018771.3
3Display Results1171170.0502340.0
 (SQL Overall)1786911177.62623431.8
 
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.