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

143 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
whoopie1529593(None) 
whoopee15287511whoopee
whoopies16267371whoopies
dhootie1136472dhootie
hoodie105116142_hoodie
hoolie93217782_hoolie
hoopoe11911232_hoopoe
whoop134211442whoop__
whooped16326932whooped
whoopees16294822whoopees
whooper15297152whooper
whooping17286632whooping
whoopla1542632whoopla
whoops14487862whoop_s
whoosis1335452whoosis
woodie103513612w_oodie
woolie93514482w_oolie
blooie83913193bloo_ie
boobie104015293_boobie
boogie93515993_boogie
bookie123516003_bookie
bootie85421163_bootie
brookie1347373brookie
chappie16298663chappie
cheapie1437563cheapie
chippie16297693chippie
choose115116143choo_se
choosier1337173choosier
chopin132712193ch_opin
chopine143512263ch_opine
choppier17286643choppier
cookie123716043_cookie
coolie83821603_coolie
cootie84223093_cootie
cowpie133511513_cowpie
croppie13278793croppie
dhoolies1246963dhoolies
dhooti1035663dhooti_
dhooties1237643dhooties
dhootis1135683dhootis
doobie94712683_doobie
doolie73916833_doolie
doozie163910653_doozie
droopier1145573droopier
flooie93712153floo_ie
floosie10378933floosie
floozie19295463floozie
foodie104413843_foodie
footie94718143_footie
ghoulie1144263ghoulie
goodie83613993_goodie
goonie73615563_goonie
goopier103910573_goopier
groupie1045783groupie
hempie132410563_hempie
hippie132811243_hippie
hoagie102310013_hoagie
hogtie102711773_hogtie
homie104622533_h_omie
honkie133011673_honkie
hoochie1537803_hoochie
hoodier113812973_hoodier
hoodies113419833_hoodies
hookier143811673_hookier
hookies144017443_hookies
hoop96129983_hoop__
hooped125518183_hooped
hooper114518313_hooper
hooping133615703_hooping
hoopla1147633_hoopla
hooplike1736773_hooplike
hoopoes121212483_hoopoes
hoopoo1198753_hoopoo
hoops105621073_hoop_s
hootier104915353_hootier
hope96639673_h_op_e
hoppier143110703_hoppier
hopple132910483_hopple
hospice14117063_hospice
hottie92514383_hottie
howdie13349733_howdie
kookie9389843_kookie
koppie14277883_koppie
looie55624243_loo_ie
loonie64216453_loonie
loopier93711193_loopier
noogie73612313_noogie
nookie103712433_nookie
oorie53026363__oorie
photopia1549733photopia
photopic17411093photopic
potpie103412433_potpie
roofie93411173_roofie
rookie103613263_rookie
roomie83013873_roomie
sharpie1238403sharpie
shoppe133110323sh_oppe
shortie10411343shortie
sinopie948783sinopie
snoopier10177273snoopier
stoolie739723stoolie
swoopier13175143swoopier
thorpe113610093thorp_e
toonie63617993_toonie
twoonie1034423twoonie
weepie11258793w_eepie
wheelie1336193wheelie
wheeple1534853wheeple
whippier18265823whippier
whole114418093wh_o_le
whomp155011323whomp__
whomped18345473whomped
whomping19285943whomping
whomps16457603whomp_s
whoof144612693whoo__f
whoofed17374513whoofed
whoofing18234833whoofing
whoofs15457243whoo_fs
whoopers16286263whoopers
whooplas1644013whooplas
whoosh15244353whoo_sh
whooshed1833453whooshed
whooshes1734423whooshes
whoosises1543423whoosises
whop125520923wh_op__
whopped18358003whopped
whopper17328503whopper
whopping19357373whopping
whops135013933wh_op_s
whore116018043wh_o_re
whortle13335943whortle
whose114914533wh_o_se
whosis1237173wh_osis
wicopies1545983wicopies
woodier113912063w_oodier
woodies113517153w_oodies
woodpile1444093woodpile
woolier103612353w_oolier
woolies104117363w_oolies
woops104917523w_oop_s
woopsed1344733w_oopsed
woopses1237883w_oopses
woozier19347323w_oozier

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271437.86017051.8
3Display Results1431430.0931537.6
 (SQL Overall)1786911438.37321341.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.