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

243 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
choppier1728664(None) 
chippier17297671chippier
chopper163611891chopp_er
hoppier143110701_hoppier
chappie16298652chappie_
chappies172610092chappies
chipper163912582chipp_er
chippie16297692chippie_
chippies17309752chippies
chirpier15276302chirpier
chokier1638042cho_kier
chomper163810072chomp_er
choosier1337172choosier
chopped174511002chopp_ed
choppers174110462chopp_ers
choppiest18226372choppiest
choppily2044132choppily
chopping183710262chopping
copier103722892c_o_pier
copper124321892c_opp_er
crappier14288132crappier
cropper133312962cropp_er
croppie13278792croppie_
croppies143111132croppies
croupier1246882croupier
cuppier1368322c_uppier
floppier1554632floppier
gloppier1354672gloppier
happier143312032_happier
hippier143212102_hippier
hopper134218482_hopp_er
loppier11369722_loppier
shopper143312632shopp_er
sloppier1255702sloppier
soppier112711582_soppier
whippier18265822whippier
whopper17328502whopp_er
bopper123813833_bopp_er
campier133313273c_ampier
caponier1237883caponier
capper124421983c_app_er
chaffier1935473chaffier
chalkier1736753chalkier
champer163813413champ_er
chancier1538823chancier
chapiter1536603chapiter
chapped172711443chapp_ed
chapping183710723chapping
chapter144213853ch_apter
charier124317903ch_arier
charrier1378683charrier
chattier1337513chattier
cheaper144010583cheap_er
cheapie1437563cheapie_
cheapies1539033cheapies
cheekier1735103cheekier
cheeper143610743cheep_er
cheerier1348003cheerier
cheesier1335963cheesier
chertier1387873chertier
chestier1387423chestier
chewier1537593ch_ewier
chichier1836023chichier
chillier13328423chillier
chinkier17377363chinkier
chipped174110813chipp_ed
chippers173510883chipp_ers
chippiest18256803chippiest
chipping18389793chipping
chirper14359963chirp_er
choicer14197893cho_icer
choir105313603cho__i_r
choker154314373cho__ker
choler113717153cho__ler
chomped17329773chomp_ed
chompers17369593chomp_ers
chomping18339883chomping
chooser124412973cho_oser
chopin132712193cho_pi_n
chopine143512263cho_pine
chopines152711733chopines
chopins142312243cho_pins
choppered1964883choppered
choppiness1973563choppiness
choppy18376293chopp__y
chortler13336843chortler
chouser125212943cho_user
chowder16387813cho_wder
chromier1538033chromier
chubbier1733893chubbier
chuffier1934543chuffier
chummier1734513chummier
chunkier17395883chunkier
cioppino1443343cioppino
clapper134011863clapp_er
clipper133710323clipp_er
cloddier1234063cloddier
cloggier1244253cloggier
clopped143611523clopp_ed
clopping153511083clopping
clothier1335363clothier
cloudier1135053cloudier
clumpier1435583clumpier
coalier93416183c_oalier
cobbier133410163c_obbier
cockier154013623c_ockier
collier93618153c_ollier
comfier1439163c_omfier
compeer133811553c_ompeer
compiler1438373c_ompiler
complier14310253complier
cooper104221123c_oop_er
coper95336093c_o_p_er
copied114618563c_o_pied
copiers114215963c_o_piers
copies104130303c_o_pies
copped135221253c_opp_ed
coppers133519753c_opp_ers
coppery16409393c_opp_ery
coppice1537483c_oppice
coppiced1734823c_oppiced
coppices1638243c_oppices
copping143918593c_opping
copter109822013c_o_pter
corkier133114303c_orkier
cornier93017093c_ornier
cosier84423753c_o_sier
cottier93814173c_ottier
coupler114713013c_oupler
courier93617893c_ourier
cowier113616163c_o_wier
cowpie133511513c_owpie_
cowpies143314283c_owpies
cozier173315143c_o_zier
crampier14288903crampier
crapper133913193crapp_er
crappie13298983crappie_
crappies142911153crappies
creepier1236253creepier
crepier1139743c_repier
crimpier14287323crimpier
crippler14826713crippler
crispier12297253crispier
croakier14436263croakier
cropped143812063cropp_ed
croppers143311483cropp_ers
cropping153210883cropping
crosier94116573cro_sier
croupiers1334653croupiers
crozier18369933cro_zier
crupper13338563crupp_er
cupper124313863c_upp_er
dippier123111393_dippier
dopier93515923_do_pier
drippier1385043drippier
droopier1145573droopier
dropper12329873dropp_er
flappier1544293flappier
flopper14328473flopp_er
floppies1546813floppies
gappier12369843_gappier
ghostier1235383ghostier
goopier103910573_goopier
grippier1355203grippier
hempier14319003_hempier
hepper133412663_hepp_er
hipper133818023_hipp_er
hippie132811243_hippie_
hippies142813743_hippies
hoarier104211743_hoarier
hokier134214033_ho_kier
holier94921623_ho_lier
homier116416993_ho_mier
hoodier113812973_hoodier
hookier143811673_hookier
hooper114518313_hoop_er
hootier104915353_hootier
hoper105829143_ho_p_er
hopped144318113_hopp_ed
hoppers143115143_hopp_ers
hoppiest152610723_hoppiest
hopping154115273_hopping
hopple132910483_hopple_
hoppled15338083_hoppled
hopples142810713_hopples
hornier103012463_hornier
horsier103013243_horsier
hosier94219613_ho_sier
humpier143110723_humpier
koppie14277883_koppie_
koppies153210013_koppies
lippier112710573_lippier
loopier93711193_loopier
lopper103717203_lopp_er
mopier103914783_mo_pier
mopper126215003_mopp_er
nappier114411173_nappier
nippier11319833_nippier
pappier103511593_pappier
peppier10268323_peppier
phonier122710633pho_nier
popper93615963_popp_er
poppied11388983_poppied
poppies102816193_poppies
preppier1156643preppier
quippier2133773quippier
ropier84118803_ro_pier
roupier9319493_roupier
sappier113613113_sappier
scrappier1544423scrappier
shipper143514043shipp_er
shoalier1137073shoalier
shoddier1334213shoddier
shoppe133110323shopp_e_
shopped153512213shopp_ed
shoppers153010763shopp_ers
shoppes143411393shopp_es
shopping163611293shopping
showier1339103sho_wier
slippier1256533slippier
snappier1266213snappier
snippier1255793snippier
snoopier10177273snoopier
soapier93411713_soapier
soupier93111753_soupier
stopper113012603stopp_er
stroppier1364453stroppier
swoopier13175143swoopier
thornier1135323thornier
tippier113210543_tippier
topper103817603_topp_er
trippier1246623trippier
unhappier1642393unhappier
whapper17348273whapp_er
whipper173611383whipp_er
whooper15297153whoop_er
whoopie15295933whoopie_
whoopies16267373whoopies
whopped18358003whopp_ed
whoppers18297533whopp_ers
whopping19357373whopping
zappier20458373_zappier
zippier20308193_zippier

Search took 8 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.423422437.4
2DLD Change Limit1461622436.48322545.4
3Display Results2432430.0962531.3
 (SQL Overall)1786912437.00225520.0
 
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.