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

365 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
woopses123788(None) 
woopsed1344731woopsed
copses104922472_copses
corpses113913802corpses
gooses75723062goo_ses
hoopoes121212482hoopoes
looses67328252loo_ses
nooses65623652noo_ses
rooses65526242roo_ses
tootses72910772tootses
whoopees16294822whoopees
whoopies16267372whoopies
woodies113517152woodies
woolies104117362woolies
woops104917522woop__s
wooshes13169882wooshes
worses95522952w_orses
apoapses1244723apoapses
apposes11511473apposes
apses76823913__apses
arouses74921293arouses
asepses946363asepses
atopies92816433atopies
biopsies1237383biopsies
blouses94014463blouses
bolases93315003bolases
boluses94113833boluses
bonuses94212953bonuses
boobies113718203boobies
boodies103721443boodies
boodles103416043boodles
boogies103719013boogies
bookies133819403bookies
boonies93422483boonies
boosts86115013boo_sts
bootees94114473bootees
booties94124613booties
boozes174916523boo_zes
bosses85925403_bosses
bourses94014303bourses
bouses84931783_bouses
bowses115718863_bowses
broses86524403bro_ses
browses124712693browses
chooses125717433chooses
choses115825133cho_ses
chouses125117813chouses
chowses155611283chowses
closes85425593clo_ses
composes145017123composes
cooches143515833cooches
cooees85621893coo_ees
cookies133719273cookies
coolies93824963coolies
coombes133810663coombes
cooped114821603coop_ed
cooper104221123coop_er
coopers114019483coopers
coops96229643coop__s
coopted123710763coopted
coopts105814583coop_ts
cooties93725733cooties
copes97747103_cop_es
copies104130303_copies
copse95623923_copse_
corpse104013403corpse_
corpuses12310063corpuses
corses84433463_corses
coses76949493_co_ses
coupes105022523coup_es
couples115317053couples
courses94218893courses
cowpies143314283cowpies
crosses94220793crosses
deposes103117213deposes
doobies103915673doobies
doodies94218773doodies
doodles93614163doodles
doofuses1244283doofuses
doolees83711613doolees
doolies83920713doolies
doozies173812723doozies
dopes84935043_dop_es
doses65938503_do_ses
dosses76126273_dosses
douses74928933_douses
dowses105718303_dowses
dropsies1138693dropsies
drosses84513823drosses
drowses114610233drowses
elapses957663elapses
elopes85918163elop_es
epopees1137233epopees
eposes84418783epo_ses
eroses65327053ero_ses
exposes1639963exposes
flosses103411973flosses
focuses12159653focuses
foodies113416753foodies
footies103721543footies
footles103715713footles
footsies1139643footsies
foozles19329543foozles
fosses96022083_fosses
glosses84014123glosses
gnoses76515163gno_ses
goodies93516993goodies
goonies83618333goonies
goopier103910573goopier
goopiest112710553goopiest
goops86620963goop__s
goose65925903goo_se_
goosed86817033goo_sed
goosey105913513goo_sey
gorses74723293_gorses
gropes95220403grop_es
grosses84517683grosses
grouses84616543grouses
hocuses121710433hocuses
hoises94823683_hoises
hooches153812523hooches
hoodies113419833hoodies
hookies144017443hookies
hooped125518183hoop_ed
hooper114518313hoop_er
hoopers123616493hoopers
hooplas1239213hooplas
hoopless13279263hoopless
hoopoe11911233hoopoe_
hoopoos1298543hoopoos
hoops105621073hoop__s
hoopster1335543hoopster
hoopsters1445693hoopsters
hooves124815493hoo_ves
hopes105835643_hop_es
hopples142810713hopples
horses94729353_horses
hoses85443183_ho_ses
houses96032283_houses
imposes113213683imposes
iodises83413633iodises
ionises72916433ionises
joneses1438963joneses
josses135117683_josses
kopjes1935363_kopjes
koppies153210013koppies
lapses85217693_lapses
loesses7310033loesses
loobies93814103loobies
looies65025833loo_ies
loonies73919543loonies
looped95217173loop_ed
looper83817113loop_er
loopers93914033loopers
loopier93711193loopier
loopiest103011323loopiest
loops75723963loop__s
loose56627683loo_se_
loosed75520893loo_sed
loosen66615963loo_sen
loosens716310963loo_sens
looser65219943loo_ser
loosest75811563loo_sest
lopes76437343_lop_es
lorises73918593lorises
loses56742013_lo_ses
losses65925233_losses
lotoses73713653lotoses
lotuses74011253lotuses
loupes84918053loup_es
louses66230283_louses
mioses84318853mio_ses
momuses1159273momuses
mooches143714453mooches
moonset92413043moonset
moonsets10216413moonsets
moose76327193moo_se_
mopes95134983_mop_es
mopokes1536693mopokes
mosses85527683_mosses
mouses85531423_mouses
mousses94012703mousses
myopes13419963myop_es
myopies14309723myopies
myoses114013843myo_ses
noises65021853_noises
nonuses73313863nonuses
noodges9317713noodges
noodles83513193noodles
noogies82814583noogies
nookies113414963nookies
noose55624063noo_se_
noosed75018013noo_sed
nooser65517823noo_ser
noosers74913933noo_sers
noses55435643_no_ses
nouses64627163_nouses
oases55330983__oases
onuses65616253_onuses
oodles73517183_oodles
oops65232673_oop__s
oozes145418713_oo_zes
opes65942613__op_es
opposes1149243_opposes
opuses84012243_opuses
oses46641513__o_ses
ouphes113614633_ouphes
peoples11312223peoples
poises84226543_poises
pooches143214163pooches
poodles103013513poodles
pooped113915943poop_ed
poops94422413poop__s
pooves113914713poo_ves
popes95933813_pop_es
poppies102816203poppies
popples103011873popples
popsies112816463_popsies
poses74642763_po_ses
posses85128803_posses
potpies113116173potpies
proposes122515973proposes
proses84733473pro_ses
prosses94019513prosses
ptoses83514673pto_ses
pyoses114314303pyo_ses
reposes94021263reposes
roofies103014413roofies
rookies113917103rookies
roomies93017243roomies
roose56127093roo_se_
roosed75621593roo_sed
rooser63921883roo_ser
roosers74217883roo_sers
roosts64916323roo_sts
rootles73215633rootles
ropes75940063_rop_es
roses56445773_ro_ses
rouses65436283_rouses
scopes104719593scop_es
scouses93313243scouses
sepses84515883_sepses
shoppes143411403shoppes
slopes84820453slop_es
soothes103917113soothes
soroses73117493soroses
souses64229243_souses
spouses92912813spouses
stopes84525893stop_es
swooped13418753swoop_ed
swooper12389173swoop_er
swoopers13317523swoopers
swoopier13175143swoopier
swoopiest14155393swoopiest
swoops114910923swoop__s
swooshes14185123swooshes
synopses1346223synopses
tonuses73612193tonuses
toonies73719883toonies
tootles72915603tootles
tootsies848613tootsies
topees85519703_topees
topes76941763_top_es
tophes115218423_tophes
topples113111653topples
torses64727953_torses
tosses65225393_tosses
toupees938513toupees
touses64229673_touses
tropes84824353trop_es
twoonies1155693twoonies
wampuses1534113wampuses
wamuses1237023wamuses
weepies122811743weepies
wholes124616773who_les
whooped16326933whoop_ed
whoopee15287513whoop_ee
whooper15297153whoop_er
whoopers16286263whoopers
whoopie15295933whoopie_
whooplas1644013whooplas
whoops14487863whoop__s
whooshes1734423whooshes
whoosis1335453whoosis
whoosises1543423whoosises
whopped18358003whopped
whopper17328503whopper
whoppers18297533whoppers
whops135013933whop__s
whores125617103who_res
whose114914533who_se_
whosis1237173who_sis
whosises1435333whosises
wicopies1545983wicopies
wimples143311173wimples
wipes104827083w_ip_es
wises85633193w__ises
wisses94619603w_isses
wobbles143412433wobbles
wodges117413683w_odges
woeness1020211543woeness
woes76440663w_o__es
wolves124510853w_olves
wooded114213683woo_ded
wooden103610303woo_den
woodhen1454723woodhen
woodhens1534103woodhens
woodie103513613woodie_
woodier113912063woodier
woodiest123112073woodiest
woodless12278453woodless
woodmen1356053woodmen
woodpiles1543983woodpiles
woods95723033woo__ds
woodshed1644213woodshed
woodsheds1742943woodsheds
woodsia1144173woodsia
woodsias1244923woodsias
woodsier1245473woodsier
woodsiest1335203woodsiest
woodsmen1444633woodsmen
woodsy13505923woods_y
wooed94419873woo__ed
wooer84316693woo__er
wooers93712443woo_ers
woofed134511203woo_fed
woofer124411363woo_fer
woofers133810583woofers
woofs114918003woo__fs
wooled103715503woo_led
woolen93111373woo_len
woolens10398843woolens
wooler93615873woo_ler
woolers104214023woolers
woolie93514483woolie_
woolier103612353woolier
wooliest113011643wooliest
woolled1136643woolled
woollen1034723woollen
woollens1144093woollens
woollies1147413woollies
woolmen1234973woolmen
wools84421463woo__ls
woolshed1553923woolshed
woolsheds1642553woolsheds
woopsing1435633woopsing
woos76238803woo___s
woosh113710733woo_s_h
wooshed14167403wooshed
woozier19347323woozier
wooziest20327903wooziest
wops96634153w_op__s
worries104117133worries
worse86525263w_orse_
worsen95513873w_orsen
worsens104610263w_orsens
worser95117523w_orser
worset96726583w_orset
worsets105512843w_orsets
worsts96014333w_orsts
wowser125110203w_owser
wowsers13488763w_owsers
wrasses103812593wrasses
wusses93314893w_usses
zoonoses1746203zoonoses

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.393454684.5
2DLD Change Limit1340273656.07622058.4
3Display Results3653650.1402607.1
 (SQL Overall)1786913656.60927037.5
 
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.