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

160 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
outfox163613(None) 
outbox1537451outbox
outdo6312702outdo_
outfit93014942outfit
outflow1355352outflow
outfly1238272outfly
outfool1037332outfool
outfoot10411492outfoot
outfoxed1936012outfoxed
outfoxes1836742outfoxes
outgo6312092outgo_
outrow9311172outrow
author939763author
auto47432083aut_o_
autos56523323aut_os
bouton8311533bout_on
buffo135112183buffo_
buffos14447853buffos
buteo75419893buteo_
buteos84913413buteos
button8310273button
cutoff1436563cutoff
detox13310953det_ox
fox136737863___fox
futon83113773fut_on
hatbox1835133hatbox
hotbox1835693hotbox
lummox1733053lummox
mouton8410853mout_on
muskox1933953muskox
muton73817003mut_on
mutton8510453mutton
octroi837363octroi
onto46127663ont_o_
option83612713option
ortho8312293ortho_
otto45220643o_tto_
ottos54714323o_ttos
out38072153out___
outact8317203outact
outadd837803outadd
outage72017533outage
outask1039103outask
outate62923403outate
outbeg938733outbeg
outbid91411853outbid
outboxed1836873outboxed
outboxes1737823outboxes
outbuy1146943outbuy
outby10411533out_by
outbye1147913outbye
outcome11310573outcome
outcook1337203outcook
outcrop1146773outcrop
outcrow1246343outcrow
outcry1137993outcry
outdid81210913outdid
outdoer849263outdoer
outdoes8313113outdoes
outdone8311643outdone
outdoor836703outdoor
outdrop1036193outdrop
outeat62824533outeat
outed65429063out_ed
outer55633303out_er
outers64230163outers
outface123011973outface
outfall1039683outfall
outfast101412123outfast
outfawn1335983outfawn
outfeel1037543outfeel
outfelt10310603outfelt
outfind1139563outfind
outfire1049713outfire
outfish132210573outfish
outfits102210833outfits
outflew1336423outflew
outfloat1146243outfloat
outflown1464063outflown
outflows1445463outflows
outfools1136533outfools
outfoots1136883outfoots
outfound1245763outfound
outfoxing20115603outfoxing
outfrown1444863outfrown
outgas7313203outgas
outglow1154863outglow
outgoes8312643outgoes
outgone8311463outgone
outgrow1136323outgrow
outgun7349643outgun
outhit92818463outhit
outhowl1337203outhowl
outing74128153outing
outjinx2135813outjinx
outjut13610053outjut
outlaw9279643outlaw
outlay92711793outlay
outled74020343outled
outlet63728683outlet
outlie62419523outlie
outlook1138023outlook
outlove102410243outlove
outman83115033outman
outmode10199663outmode
outmost9511213outmost
outmove12238713outmove
outplod10106343outplod
outplot9109483outplot
outpoll946793outpoll
outport9714123outport
outpost9612443outpost
outpour937413outpour
output8712853output
outran63218883outran
outre53922193out_re
outrig72812843outrig
outroar739513outroar
outrock1339303outrock
outrode82313423outrode
outroll749303outroll
outroot7516563outroot
outrows10311403outrows
outrun63213293outrun
outs45746963out__s
outsat62920283outsat
outsaw92610283outsaw
outsay92611873outsay
outsee63121803outsee
outset64027453outset
outshot10312103outshot
outsin63617553outsin
outsit63620883outsit
outsoar739493outsoar
outsold8109073outsold
outsole71013433outsole
outtold8107603outtold
outtrot7312613outtrot
outvie92412793outvie
outvote1038803outvote
outwar91011513outwar
outwit93014583outwit
outwore101912693outwore
outwork141710353outwork
outworn101610753outworn
ouzo133516933ou_zo_
ouzos143210413ou_zos
postbox1885493postbox
postfix1944673postfix
poutful1236743poutful
putlog965553putlog
putoff1436423putoff
puton73617913put_on
putto75617663putto_
subfix1835073subfix
suffix1935233suffix
sulfo8313363sulfo_
tutor5712493tut_or
unbox1438753_unbox
unfix15429033_unfix

Search took 9 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 Limit1127161608.15313825.1
3Display Results1601600.0632539.7
 (SQL Overall)1786911608.35921377.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.