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

297 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
crappies14291116(None) 
chappies172610101chappies
crappie13298981crappie_
crappier14288131crappier
crappiest15267271crappiest
croppies143111131croppies
chappie16298662chappie_
chippies17309762chippies
crampier14288902crampier
crampiest15268622crampiest
crampits1436272crampits
crannies10313012crannies
crapes104727692cra_p_es
crapped143912622crapp_ed
crapper133913192crapp_er
crappers144011022crappers
crapping153911452crapping
crazies183413852cra_zies
creepies1239612creepies
cripples14298402cripples
croppie13278792croppie_
frappes14328382frapp_es
grapples13348122grapples
nappies114613402_nappies
pappies103214832_pappies
preppies1149692preppies
rappees113611452_rappees
scrapies124612482scra_pies
scrappier1544432scrappier
scrappiest1644162scrappiest
scrapples1534802scrapples
apples104315763__apples
applies11311223__applies
brandies11714563brandies
brassies103613533brassies
braxies16711463bra_xies
buppies133011063_buppies
cabbies133115163c_abbies
caddies113718383c_addies
cammies134016483c_ammies
campier133313273c_ampier
campiest142212143c_ampiest
candies104125613c_andies
canopies12311853canopies
capes95441923c_a_p_es
capias10318353c_a_pias
capizes20410373c_apizes
caplins113515993c_aplins
capotes11314643c_apotes
capped134721853c_app_ed
capper124421983c_app_er
cappers134419403c_appers
capping143819673c_apping
cappings15369493c_appings
caprices1439893c_aprices
capris10415083c_apri_s
capsids1239333c_apsids
capsizes2147203c_apsizes
captives1538623c_aptives
carapaces1546053carapaces
carapaxes2044833carapaxes
caries85147623c_a_ries
carnies94123963c_arnies
carries94328013c_arries
catties94023053c_atties
cavies114525003c_a_vies
challies133915643challies
chammies172910163chammies
chanties132615803chanties
chapes135421873cha_p_es
chapped172711443chapp_ed
chapping183710723chapping
charlies133414233charlies
cheapies1539033cheapies
chippie16297693chippie_
chippier17297673chippier
chippiest18256813chippiest
choppier17286643choppier
choppiest18226383choppiest
clapped143511173clapp_ed
clapper134011863clapp_er
clappers143310833clappers
clapping153810603clapping
claries93422203cla_ries
coalpits1245403coalpits
complies14314523complies
copies104130303c__opies
coppices1638243c_oppices
cowpies143314283c_owpies
crabapples1851043crabapples
crabbier14326803crabbier
crabbiest1535623crabbiest
crabwise1543613crabwise
crackles164111273crackles
cradles103114133cra_dles
craftier1376193craftier
craftiest1436913craftiest
craggier12116063craggier
craggiest13116523craggiest
crakes124921813cra__kes
crambes1339963cra_mbes
cramboes1436543cramboes
cramped144712183cramp_ed
cramping153411853cramping
crampit1338863crampi_t
crampons1436643crampons
cramps125615563cramp__s
cranches153114543cranches
cranes84330753cra__nes
crankier14339163crankier
crankiest1538823crankiest
crankles143510153crankles
crankpins17133763crankpins
crannied1137893crannied
crape96128443cra_p_e_
craped116120523cra_p_ed
craping124018713cra_ping
crapolas1247403crapolas
crappy15446803crapp__y
craps95328643cra_p__s
crases85532313cra__ses
crashes124618403cra_shes
crasis85020473cra_si_s
cratches153012543cratches
crates85736063cra__tes
craves115825393cra__ves
crawlier13216873crawlier
crawliest14187403crawliest
crazes174720133cra__zes
crazier183610743cra_zier
craziest19319923cra_ziest
creepie1137483creepie_
creepier1236253creepier
creepiest1337063creepiest
crepes105419343cr_ep_es
crepier1139743cr_epier
crepiest12310383cr_epiest
cries75438403cr___ies
crimpier14287323crimpier
crimpiest15237183crimpiest
crimples14308963crimples
cripes105120873cr_ip_es
cripple13378583cripple_
crippled15336793crippled
crippler14826713crippler
cripplers15314993cripplers
crispier12297253crispier
crispiest13197423crispiest
cronies9622503cr_onies
cropped143812063cropp_ed
cropper133312963cropp_er
croppers143311483croppers
cropping153210883cropping
croupes114613103croup_es
croupier1246883croupier
croupiers1334653croupiers
croupiest1337063croupiest
crowdies1437553crowdies
crummies1437643crummies
crumples14348813crumples
crupper13338563crupp_er
cruppers14317323cruppers
cuppier1368323c_uppier
cuppiest1448203c_uppiest
curacies12311763cura_cies
dapples1238993_dapples
draperies1249193draperies
drapes95419653dra_p_es
drippier1385043drippier
drippiest1445373drippiest
dropsies1138693dropsies
flappier1544303flappier
flappiest1644863flappiest
floppies1546823floppies
frappe13286953frapp_e_
frapped15318853frapp_ed
frapping16348103frapping
gappier12369843_gappier
gappiest13259483_gappiest
grannies9312613grannies
graperies1239613graperies
grapes95123123gra_p_es
graphics1645653graphics
graphites1546823graphites
grapier103712603gra_pier
grapiest112211933gra_piest
graplines1237353graplines
graplins1148263graplins
grappas12357103grapp_as
grapple12378003grapple_
grappled14336093grappled
grappler13336193grappler
grapplers14274303grapplers
gravies11314093gra_vies
grippes124810373gripp_es
grippier1355203grippier
grippiest1435153grippiest
groupies1137523groupies
guppies123310523_guppies
happier143312043_happier
happiest152411683_happiest
harpies123818323_harpies
hippies142813753_hippies
koppies153210013_koppies
magpies12310363_magpies
nappes104515623_napp_es
nappie104112263_nappie_
nappier114411173_nappier
nappiest122510893_nappiest
pappier103511603_pappier
pappiest112611123_pappiest
poppies102816203_poppies
prairies10411453prairies
preapplies1343323preapplies
preppie1058093preppie_
preppier1156643preppier
preppiest1236983preppiest
puppies103212623_puppies
rabbies113416053_rabbies
rabies85226023_ra_bies
raggies93214733_raggies
rallies73823343_rallies
ramies84630463_ra_mies
rampikes1635393_rampikes
randies84225663_randies
ranpikes1435643_ranpikes
rapes75740723_ra_p_es
raphes115117453_ra_phes
raphias123511083_raphias
raphides14188393_raphides
raphis114014323_raphi_s
rapids94913893_ra_pids
rapier84019993_ra_pier
rapiers95012873_ra_piers
rapines95120863_rapines
rapped114122683_rapp_ed
rappee103618673_rapp_ee
rappel104211953_rapp_el
rappels11448803_rappels
rappen103512713_rapp_en
rapper104621573_rapp_er
rappers113618443_rappers
rapping123619103_rapping
rappini11347573_rappini
raspier93110643_raspier
raspiest10311283_raspiest
reapplies1344923reapplies
replies94521043_replies
ripples113513293_ripples
sappier113613123_sappier
sappiest122612583_sappiest
scampies1439333scampies
schappes1736043schapp_es
scrapes116217663scra_p_es
scrapie115010943scra_pie_
scrappages1742433scrappages
scrapped1556533scrapp_ed
scrapper1466973scrapp_er
scrappers1545863scrappers
scrappily1842673scrappily
scrappiness1752293scrappiness
scrapping1635743scrapping
scrapple1434683scrapple_
sharpies13411233sharpies
snappier1266223snappier
snappiest1346503snappiest
strappier1345143strappier
strappiest1444383strappiest
tawpies12309873_tawpies
traipses1036873traipses
trampier12318243trampier
trampiest13227903trampiest
tramples122610203tramples
trannies8415013trannies
trapes85024463tra_p_es
trapeses1039153trapeses
trapezes1936543trapezes
traplines11310373traplines
trapped124512213trapp_ed
trapper113912803trapp_er
trappers123711043trappers
trapping132911393trapping
trappings14265753trappings
trappose1245813trappose
trappous1246023trappous
trippier1246623trippier
trippiest1336593trippiest
trophies13413673trophies
wrapped15338023wrapp_ed
wrapper14368333wrapp_er
wrappers15306933wrappers
wrapping16297623wrapping
wrappings17253713wrappings
yippies14279293_yippies
yuppies14339263_yuppies
zappier20458373_zappier
zappiest21228033_zappiest

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.406440125.6
2DLD Change Limit1461622977.29620033.2
3Display Results2972970.1262357.1
 (SQL Overall)1786912977.82822827.2
 
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.