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

266 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
chappies17261009(None) 
chappie16298651chappie_
chippies17309751chippies
crappies142911151crappies
challies133915632challies
chammies172910152chammies
chanties132615802chanties
chapes135421872cha_p_es
chapped172711442chapp_ed
chapping183710722chapping
charlies133414222charlies
cheapies1539032cheapies
chippie16297692chippie_
chippier17297672chippier
chippiest18256802chippiest
choppier17286642choppier
choppiest18226372choppiest
crappie13298982crappie_
crappier14288132crappier
crappiest15267262crappiest
croppies143111132croppies
happier143312032_happier
happiest152411672_happiest
harpies123818312_harpies
hippies142813742_hippies
nappies114613392_nappies
pappies103214822_pappies
schappes1736032schapp_es
sharpies13411222sharpies
apples104315763__apples
applies11311213__applies
buppies133011063_buppies
cabbies133115163c_abbies
caddies113718383c_addies
cammies134016473c_ammies
campier133313273c_ampier
campiest142212133c_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
capris10415073c_apri_s
capsids1239333c_apsids
capsizes2147203c_apsizes
captives1538623c_aptives
caries85147623c_a_ries
carnies94123963c_arnies
carries94328013c_arries
catties94023053c_atties
cavies114525003c_a_vies
chablis14368553chabli_s
chafes145017913cha__fes
chaffier1935473chaffier
chaffiest2045403chaffiest
chagrins1437063chagrins
chaines124518733cha_ines
chains114819703cha__ins
chairs114916173cha__irs
chais107530313cha__i_s
chaise114916413cha__ise
chaises124317493cha_ises
chalcids1635883chalcids
chalices15310813chalices
chalkier1736753chalkier
chalkiest1837083chalkiest
challie124012853challie_
challis124613463challi_s
challises14358783challises
chalones13312173chalones
chamades16138633chamades
chamise143612853cha_mise
chamises153513313chamises
chammied18215963chammied
chamois143512173chamoi_s
chamoises16327933chamoises
champacs1934623champacs
champaks2134093champaks
champed174111473champ_ed
champer163813403champ_er
champers173311613champers
champing183610933champing
champion17276353champion
champions18875783champions
champs154915683champ__s
chances145218093cha_nces
chancier1538823chancier
chanciest1638373chanciest
chancres15429363chancres
changes134517583cha_nges
chantries14310273chantries
chaoses124715113cha_oses
chapatis15127923chapatis
chape125221143cha_p_e_
chapeaus1544973chapeaus
chapel134911373cha_p_el
chapels14429153cha_pels
chapiter1536603chapiter
chapiters1635193chapiters
chaplains1645713chaplains
chaplet14512253cha_plet
chaplets1556883chaplets
chapmen1637283cha_pmen
chappati17124003chappati
chappatis18114003chappatis
chaps125326063cha_p__s
chapter144213853cha_pter
chapters154012113chapters
charades141310843charades
charases131312753charases
chares115631803cha__res
charges134615983cha_rges
charier124317903cha_rier
chariest13315503cha_riest
charities14312733charities
charlie123011923charlie_
charpais1536923charpais
charpoys1834533charpoys
charrier1378683charrier
charriest1438253charriest
chases115128233cha__ses
chasses124017503cha_sses
chassis123910663chassi_s
chastise1348173chastise
chastises1437703chastises
chattier1337513chattier
chattiest1448203chattiest
chausses1345963chausses
chayotes1636493chayotes
cheapie1437563cheapie_
cherries131812973cherries
chevies153511443ch_evies
chilies124218303ch_ilies
chillies134113473chillies
chipped174110813chipp_ed
chipper163912583chipp_er
chippers173510873chippers
chipping18389793chipping
chirpier15276303chirpier
chirpiest16286473chirpiest
chitties13310773chitties
chivies153412853ch_ivies
chivvies1954423chivvies
chopines152711733chopines
chopins142312243ch_opins
chopped174511003chopp_ed
chopper163611893chopp_er
choppers174110453choppers
choppily2044133choppily
choppiness1973563choppiness
chopping183710263chopping
chuckies1937703chuckies
chuppahs2042073chuppahs
chuppas1644123chupp_as
clapped143511173clapp_ed
clapper134011863clapp_er
clappers143310833clappers
clapping153810603clapping
claries93422203cla_ries
coalpits1245393coalpits
complies14314523complies
copies104130303c__opies
coppices1638243c_oppices
cowpies143314283c_owpies
crampier14288903crampier
crampiest15268613crampiest
crampits1436273crampits
crannies10313013crannies
crapes104727693cra_p_es
crapped143912623crapp_ed
crapper133913193crapp_er
crappers144011023crappers
crapping153911453crapping
crazies183413853cra_zies
creepies1239613creepies
cripples14298403cripples
croppie13278793croppie_
cuppier1368323c_uppier
cuppiest1448193c_uppiest
dapples1238993_dapples
flappier1544293flappier
flappiest1644853flappiest
floppies1546813floppies
frappes14328383frapp_es
gappier12369843_gappier
gappiest13259473_gappiest
gharries12318203gharries
ghazies2036913gha_zies
grapples13348123grapples
guppies123310523_guppies
hackies163418243_hackies
hankies143617763_hankies
hapaxes1936593_hapaxes
haplites1339993_haplites
happed144820103_happ_ed
happen134812193_happ_en
happens14359173_happens
happily1745763_happily
happiness1635993_happiness
happing153817233_happing
hardies114923233_hardies
harpins123615703_harpins
harries103525493_harries
hatpins123410643_hatpins
hawkies173311243_hawkies
hippie132811243_hippie_
hippier143212103_hippier
hippiest152611613_hippiest
hoppier143110703_hoppier
hoppiest152610723_hoppiest
hopples142810713_hopples
koppies153210013_koppies
magpies12310363_magpies
nappes104515623_napp_es
nappie104112263_nappie_
nappier114411173_nappier
nappiest122510883_nappiest
pappier103511593_pappier
pappiest112611113_pappiest
poppies102816193_poppies
preppies1149673preppies
puppies103212613_puppies
rappees113611453_rappees
reapplies1344913reapplies
rhaphes1534703rha_phes
sappier113613113_sappier
sappiest122612573_sappiest
scampies1439323scampies
schappe1635263schapp_e_
scrapies124612473scra_pies
scrappier1544413scrappier
scrappiest1644153scrappiest
scrapples1534793scrapples
shammies15259673shammies
shandies122714103shandies
shannies113411253shannies
shanties113116573shanties
shapes115124943sha_p_es
sharpie1238383sharpie_
shavies134213203sha_vies
shoppes143411383shopp_es
snappier1266213snappier
snappiest1346483snappiest
tawpies12309873_tawpies
unhappier1642393unhappier
unhappiest1742413unhappiest
whammies18265503whammies
whapped18367573whapp_ed
whapper17348273whapp_er
whappers18276743whappers
whapping19317113whapping
whippier18265823whippier
whippiest19265113whippiest
whoopies16267363whoopies
yippies14279293_yippies
yuppies14339263_yuppies
zappier20458373_zappier
zappiest21228023_zappiest

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.1701051123.5
2DLD Change Limit1461622667.94018408.3
3Display Results2662660.1062509.4
 (SQL Overall)1786912668.21621749.1
 
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.