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

168 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
footsie104764(None) 
footie94718131foot_ie
footsies1139641footsies
tootsie737121tootsie
bootie85421152boot_ie
cootie84223072coot_ie
floosie10378932floosie
flossie10337442flossie
foodie104413842foo_die
footage1148842footage
footier104115112foot_ier
footies103721542foot_ies
footle93914382foot_le
footlike1537252footlike
foots85528282foots__
footsore1146062footsore
footstep1363822footstep
footsy12587932foots_y
potsie83916022_potsie
tootsies848612tootsies
azotise1637073azotise
boobie104015293boo_bie
boogie93515993boo_gie
bookie123516003boo_kie
bootee84323023boot_ee
booties94124613boot_ies
boots75837973boots__
cookie123716043coo_kie
coolie83821603coo_lie
coontie9311413coontie
cooties93725733coot_ies
coots75636843coots__
cosie74728263_co_sie
couthie121810543couthie
dhootie1136453dhoot_ie
donsie7613643_donsie
doobie94712683doo_bie
doolie73916833doo_lie
doozie163910643doo_zie
falsie93513853f_alsie
fantasie11117743fantasie
flooie93712153flo_oie
floosies113210233floosies
floozie19295453floozie
flossier11326973flossier
flossies112810123flossies
flotage1136683flotage
flotsam1244613flotsam
foetid10510513foet_id
fogie96719003f_o_gie
folkie13369613f_olkie
folksier1533533folksier
fonts86124753fonts__
foodies113416753foo_dies
foods95924163foods__
foolish1339613foolish
fools86824203fools__
foot76248013foot___
footages1239053footages
footbag1344553footbag
footboy1544913footboy
footed104418623foot_ed
footer94320773foot_er
footers104618333footers
foothill1444993foothill
footiest113514913foot_iest
footing115017593footing
footled113610763footled
footler104011873footler
footles103715713footles
footling12239923footling
footman1236403footman
footmen1246583footmen
footnote1144933footnote
footpace1544493footpace
footpad1343903footpad
footrace1346413footrace
footrope1346253footrope
footslog1242663footslog
footsteps1462863footsteps
footstone1245273footstone
footway1635253footway
footy115820533foot__y
foozle18369203foo_zle
foresee10414333foresee
foreside12310303foreside
forte86131463fort__e
forties104323863fort_ies
fortis95418613fort_is
forts86034453forts__
fortune1068303fortune
fossae95510373f_ossae
fosse86119463f_o_sse
fossil9379353f_ossil
foxtail1745383foxtail
frostier1148163frostier
frothier1435953frothier
frowsier1444893frowsier
goodie83613993goo_die
goonie73615563goo_nie
goose65925903goo_s_e
goosier83512563goo_sier
hogtie102711763hogt_ie
hoochie1537783hoochie
hoodie105116133hoo_die
hoolie93217773hoo_lie
hootier104915343hoot_ier
hoots84830243hoots__
hottie92514363_hottie
kookie9389833koo_kie
looie55624243loo__ie
loonie64216453loo_nie
loose56627683loo_s_e
loots55431423loots__
moose76327193moo_s_e
moots75831663moots__
mortise9713533mortise
noogie73612313noo_gie
nookie103712433noo_kie
noose55624063noo_s_e
oorie53026363_oo_rie
ootid61416693_oot_id
oots46446443_oots__
outlie62419523_outlie
outsee63121803_outsee
outside82414193_outside
outsin63617553_outsin
outsit63620883_outsit
outsize162411753_outsize
outvie92412793_outvie
poetise9314043poetise
poolside1145043poolside
popsie103013053_popsie
portside1138163portside
postie84123963post_ie
potpie103412423_potpie
potsies93019483_potsies
poussie936623poussie
prossie91812953prossie
prostie91617743prostie
roofie93411173roo_fie
rookie103613263roo_kie
roomie83013873roo_mie
roose56127093roo_s_e
rootage839053rootage
rootier74915393root_ier
rootle63214453root_le
rootlike1236613rootlike
roots55933673roots__
scottie937443scottie
smoothie1344873smoothie
softie93312473soft_ie
sonsie6614853_sonsie
soothe94214843soot_he
sootier73916603soot_ier
soots55536203soots__
sortie63621983sort_ie
toonie63617993too_nie
toothier1136423toothier
tootle62613813toot_le
toots55331873toots__
tootses72910773tootses
tootsy9437983toots_y
woodie103513613woo_die
woodsia1144173woodsia
woodsier1245473woodsier
woolie93514483woo_lie
zootier163611173zoot_ier

Search took 10 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.1561145455.1
2DLD Change Limit1340271689.23314516.1
3Display Results1681680.1261333.3
 (SQL Overall)1786911689.51518779.9
 
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.