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

202 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
floppier155463(None) 
flappier1544291flappier
flopper14328471flopp_er
floppies1546811floppies
gloppier1354671gloppier
loppier11369721_loppier
sloppier1255701sloppier
choppier17286642choppier
flapper14359202flapp_er
flipper14389142flipp_er
floatier1136982floatier
flockier1745342flockier
flopover1642862flopover
flopped15338762flopp_ed
floppers15337462flopp_ers
floppiest1654772floppiest
floppily1843772floppily
flopping16388772flopping
flossier11326972flossier
hoppier143110702_hoppier
lippier112710572_lippier
loopier93711192_loopier
lopper103717202_lopp_er
slippier1256532slippier
soppier112711582_soppier
blockier1666133blockier
bloodier1136823bloodier
bloomier1275783bloomier
blooper11358533bloop_er
blottier10336413blottier
blousier1055663blousier
blowier1248943blo_wier
blowsier1335063blowsier
blowzier2233413blowzier
bopper123813833_bopp_er
chippier17297673chippier
chopper163611893chopp_er
clapper134011863clapp_er
clipper133710323clipp_er
cloddier1234063cloddier
cloggier1244253cloggier
clopped143611523clopp_ed
clopping153511083clopping
clothier1335363clothier
cloudier1135053cloudier
clumpier1435583clumpier
copier103722893_co_pier
copper124321893_copp_er
crappier14288133crappier
cropper133312963cropp_er
croppie13278793croppie_
croppies143111133croppies
croupier1246883croupier
cuppier1368323_cuppier
dippier123111393_dippier
dopier93515923_do_pier
drippier1385043drippier
droopier1145573droopier
dropper12329873dropp_er
eloper85414153elo_p_er
flabbier1534093flabbier
flaggier13105203flaggier
flakier143910203fl_akier
flamier123112143fl_amier
flapped15328253flapp_ed
flappers15388383flapp_ers
flappiest1644853flappiest
flapping16298153flapping
flashier1437103flashier
flawier13378733fl_awier
flaxier17337983fl_axier
fledgier1333683fledgier
fleecier1334763fleecier
fleshier1435603fleshier
flier86023403fl___ier
flimsier1344133flimsier
flintier1136393flintier
flipped15358513flipp_ed
flippers15337993flipp_ers
flipping16307663flipping
flirtier1144883flirtier
floater104413353flo_ater
flogger12449453flo_gger
flooder11258463flo_oder
flooie93712153flo_oie_
floorer10248073flo_orer
floosie10378933floosie_
floosies113210233floosies
floozie19295453floozie_
floozies20326953floozies
flopovers1742563flopovers
floppiness1742863floppiness
floppy1654873flopp__y
flosser10339693flo_sser
flossie10337443flossie_
flossies112810123flossies
flouncier1442483flouncier
flounder1235103flounder
flouter104311343flo_uter
flower124815503flo__wer
flowerer1435453flowerer
flowerier1544273flowerier
fluffier13264333fluffier
flukier14397853fl_ukier
flutier103011553fl_utier
flypaper1842223flypaper
flytier13356503fl_ytier
foamier12339003f_oamier
foggier12349913f_oggier
folkier14359043f_olkier
folksier1533533folksier
footier104115103f_ootier
fopped144012673f_opp_ed
foppery17385623f_opp_ery
fopping153511133f_opping
foppish1735103f_oppish
forkier144311583f_orkier
foxier163910033f_o_xier
fozier183710663f_o_zier
froggier1354643froggier
frontier1147313frontier
frostier1148163frostier
frothier1435953frothier
frouzier2043703frouzier
frowsier1444893frowsier
frowzier2343313frowzier
frumpier1534173frumpier
gappier12369843_gappier
globbier1334243globbier
gloomier1135093gloomier
glopped13347613glopp_ed
gloppiest1444823gloppiest
glopping14307753glopping
glossier9358203glossier
glumpier1334873glumpier
goopier103910573_goopier
grippier1355203grippier
happier143312033_happier
hippier143212103_hippier
hopper134218483_hopp_er
jaloppies2043213jaloppies
koppie14277873_koppie_
koppies153210013_koppies
lapper104319953_lapp_er
lipper104219633_lipp_er
loamier9349163_loamier
loftier1037763_loftier
loggier93811143_loggier
logier75015733_lo_gier
loonier73312673_loonier
looper83817113_loop_er
loper75129233_lo_p_er
lopped114218623_lopp_ed
loppers113014103_lopp_ers
loppiest122410103_loppiest
lopping123815223_lopping
lousier72411623_lousier
lowlier10338903_lowlier
lumpier113410143_lumpier
mopier103914783_mo_pier
mopper126215003_mopp_er
nappier114411173_nappier
nippier11319833_nippier
pappier103511593_pappier
peppier10268323_peppier
plopped11288773plopp_ed
plopping12318703plopping
plottier10327263plottier
popper93615963_popp_er
poppied11388983_poppied
poppies102816193_poppies
preppier1156643preppier
quippier2133773quippier
ropier84118803_ro_pier
roupier9319493_roupier
sappier113613113_sappier
shopper143312623shopp_er
slapper113512463slapp_er
sleepier1036783sleepier
slipper113712973slipp_er
slobbier1254633slobbier
sloper84615913slo_p_er
slopped123511443slopp_ed
sloppiest1345973sloppiest
sloppily1544613sloppily
slopping133811423slopping
sloshier1135283sloshier
snappier1266213snappier
snippier1255793snippier
snoopier10177273snoopier
soapier93411713_soapier
soupier93111753_soupier
stopper113012593stopp_er
stroppier1364443stroppier
swoopier13175143swoopier
tippier113210543_tippier
topper103817603_topp_er
trippier1246623trippier
whippier18265823whippier
whopper17328503whopp_er
zappier20458373_zappier
zippier20308193_zippier

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622028.53317129.0
3Display Results2022020.0762657.9
 (SQL Overall)1786912028.76520386.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.