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

224 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
crappie1329898(None) 
chappie16298651chappie
crappier14288131crappier
crappies142911151crappies
croppie13278791croppie
chappies172610092chappies
chippie16297692chippie
crampier14288902crampier
crampit1338862crampit
crape96128442cra_p_e
crapped143912622crapped
crapper133913192crapper
crappiest15267262crappiest
crapping153911452crapping
crappy15446802crapp_y
creepie1137482creepie
cripple13378582cripple
croppies143111132croppies
frappe13286952frapp_e
grapple12378002grapple
nappie104112262_nappie
preppie1058092preppie
rappee103618672_rappee
scrapie115010942scra_pie
scrappier1544422scrappier
scrapple1434682scrapple
apple94517673__apple
brassie93411523brassie
brawlie12198153brawlie
buppie12288733_buppie
cabbie122913353c_abbie
caddie104316453c_addie
cammie124615293c_ammie
campi116217783c_ampi_
campier133313273c_ampier
cannie83819363c_annie
cape87242783c_a_p_e
capiz18514563c_a_piz
caplin103216303c_aplin
capote10315733c_apote
capped134721853c_apped
capper124421983c_apper
capping143819673c_apping
capric12411803c_apric
caprice1349683c_aprice
caprine11314233c_aprine
capris10415083c_apris
capsid11312413c_apsid
capsize2037623c_apsize
captive1438973c_aptive
carapace1446093carapace
carnie84421093c_arnie
carpale113414353carpale
carpi94319393c_arpi_
cattie85221023c_attie
cavie104621593c_a_vie
challie124012853challie
chape125221143cha_p_e
chapped172711443chapped
chapping183710723chapping
charlie123011923charlie
cheapie1437563cheapie
chippier17297673chippier
chippies17309753chippies
choppier17286643choppier
clapped143511173clapped
clapper134011863clapper
clapping153810603clapping
coalpit1148513coalpit
coppice1537483c_oppice
cowpie133511513c_owpie
crabapple1751183crabapple
crabbier14326803crabbier
crablike1636023crablike
crabwise1543613crabwise
crackle153611253crackle
cradle93313163cra_dle
craftier1376193craftier
craggier12116063craggier
crake114823523cra__ke
crambe1239073cra_mbe
cramp115120693cramp__
cramped144712183cramped
crampiest15268613crampiest
cramping153411853cramping
crampits1436273crampits
crampon1336943crampon
cramps125615563cramp_s
crampy154710993cramp_y
crane75331603cra__ne
crania82418433cra_nia
crankier14339163crankier
crankle133610063crankle
crankpin16103753crankpin
crannied1137893crannied
crannies10313013crannies
crap85731843cra_p__
craped116120523cra_ped
crapelike1744933crapelike
crapes104727693cra_pes
craping124018713craping
crapola1136913crapola
crappers144011023crappers
craps95328643cra_p_s
crasis85020473cra_sis
crate76537403cra__te
crave105626313cra__ve
crawlier13216873crawlier
craze165221463cra__ze
crazier183610743cra_zier
crazies183413853cra_zies
creepier1236253creepier
creepies1239613creepies
crepe95520723cr_ep_e
crepier1139743cr_epier
crimpier14287323crimpier
crimple13408693crimple
cripe95521143cr_ip_e
crippled15336793crippled
crippler14826713crippler
cripples14298403cripples
crispier12297253crispier
cropped143812063cropped
cropper133312963cropper
cropping153210883cropping
croupe105114433croup_e
croupier1246883croupier
crowdie1335913crowdie
crummie1336153crummie
crumple13368363crumple
crupper13338563crupper
cryptic1646153cryptic
cuppier1368323c_uppier
dapple1138853_dapple
drape85319633dra_p_e
drippier1385043drippier
flappier1544293flappier
frapped15318853frapped
frappes14328383frappes
frapping16348103frapping
gappier12369843_gappier
grannie8310353grannie
grape84824663gra_p_e
graphic1537353graphic
graphite1447153graphite
grapier103712603gra_pier
graplin1058443graplin
grapline1138723grapline
grappa11396443grapp_a
grappas12357103grappas
grappled14336093grappled
grappler13336193grappler
grapples13348123grapples
grippe115310323gripp_e
grippier1355203grippier
gripple12416613gripple
groupie1045783groupie
happier143312033_happier
hippie132811243_hippie
koppie14277883_koppie
magpie1139093_magpie
nappe96114993_napp_e
nappier114411173_nappier
nappies114613393_nappies
pappi84810893_pappi_
pappier103511593_pappier
pappies103214823_pappies
prairie938333prairie
preppier1156643preppier
preppies1149683preppies
ramie75027823_ra_mie
rampike1536603_rampike
ranpike1335933_ranpike
rape65041633_ra_p_e
raphae114311733_raphae
raphe104916423_ra_phe
raphia113511263_raphia
raphide13138073_raphide
raphis114014323_raphis
rapid86422033_ra_pid
rapier84019993_ra_pier
rapine85023083_rapine
rapped114122683_rapped
rappees113611453_rappees
rappel104211953_rappel
rappen103512713_rappen
rapper104621573_rapper
rapping123619103_rapping
rappini11347573_rappini
raspier93110643_raspier
ripple103413913_ripple
sappier113613113_sappier
schappe1635263schapp_e
scrape105917573scra_p_e
scrapies124612473scra_pies
scrappage1642443scrappage
scrapped1556533scrapped
scrapper1466973scrapper
scrappiest1644153scrappiest
scrappily1842673scrappily
scrapping1635743scrapping
scrapples1534793scrapples
scrappy16234473scrapp_y
sharpie1238393sharpie
snappier1266213snappier
strappier1345133strappier
tawpie11339143_tawpie
traipse935873traipse
trampier12318243trampier
trample11299703trample
trapeze1836253trapeze
traplike1437653traplike
trapline10411863trapline
trapped124512213trapped
trapper113912803trapper
trapping132911393trapping
trappose1245813trappose
trippier1246623trippier
wrapped15338023wrapped
wrapper14368333wrapper
wrapping16297623wrapping
yippie13277843_yippie
yuppie13297133_yuppie
zappier20458373_zappier

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 Filter1786911340270.403443402.0
2DLD Change Limit1340272246.64320175.7
3Display Results2242240.0762947.4
 (SQL Overall)1786912247.12225090.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.