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

192 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
croppie1327879(None) 
crappie13298981crappie
croppies143111131croppies
chappie16298652chappie
chippie16297692chippie
choppier17286642choppier
coppice1537482c_oppice
cowpie133511512c_owpie
crappier14288132crappier
crappies142911152crappies
creepie1137482creepie
cripple13378582cripple
cropped143812062cropped
cropper133312962cropper
cropping153210882cropping
croupe105114432croup_e
croupier1246882croupier
crowdie1335912crowdie
groupie1045782groupie
koppie14277882_koppie
preppie1058092preppie
acrospire1343973acrospire
brookie1347373brookie
brownie12178433brownie
buppie12288733_buppie
chappies172610093chappies
cheapie1437563cheapie
chippier17297673chippier
chippies17309753chippies
chopin132712193cho_pin
chopine143512263chopine
chopped174511003chopped
chopper163611893chopper
choppiest18226373choppiest
choppily2044133choppily
chopping183710263chopping
choppy18376293chopp_y
cioppino1443343cioppino
clopped143611523clopped
clopping153511083clopping
collie83621993c_ollie
commie124215523c_ommie
compile13312443c_ompile
cookie123716043c_ookie
coolie83821603c_oolie
coontie9311423coontie
cootie84223093c_ootie
cope86847383c_o_p_e
copied114618563c_o_pied
copier103722893c_o_pier
copies104130303c_o_pies
copped135221253c_opped
copper124321893c_opper
coppiced1734823c_oppiced
coppices1638243c_oppices
copping143918593c_opping
coppra12306833c_oppra
copse95623923c_o_pse
corbie103618203c_orbie
corpse104013403c_orpse
corrie83621223c_orrie
cosie74728263c_o_sie
coupe96023483c_oup_e
couple104415963c_ouple
cowpies143314283c_owpies
cowrie113814283c_owrie
cozie163519133c_o_zie
crampier14288903crampier
crampit1338863crampit
crape96128443cr_ap_e
crapped143912623crapped
crapper133913193crapper
crappiest15267263crappiest
crapping153911453crapping
crappy15446803crapp_y
creepier1236253creepier
creepies1239613creepies
crepe95520723cr_ep_e
crepier1139733cr_epier
crimpier14287323crimpier
crimple13408693crimple
cripe95521143cr_ip_e
crippled15336793crippled
crippler14826713crippler
cripples14298403cripples
crispier12297253crispier
croakier14436263croakier
crocein1138073crocein
croceine1248033croceine
croci95818133cro_ci_
crocine11314153crocine
crocoite1248053crocoite
crojik1934113cro_jik
crone75231333cro__ne
cronies9622503cro_nies
crop87628633cro_p__
croppers143311483croppers
crops96125233cro_p_s
croquis1834763croquis
crore74922863cro__re
crosier94116573cro_sier
crosse85216303cro_sse
crosstie1046933crosstie
croup95616783croup__
croupes114613103croupes
croupiers1334653croupiers
croupiest1337063croupiest
croupily1544743croupily
croups104312553croup_s
croupy13458733croup_y
crouse84619363cro_use
croute84617273cro_ute
crowdies1437553crowdies
croze164719453cro__ze
crozier18369933cro_zier
crummie1336153crummie
crumple13368363crumple
crupper13338563crupper
cryptic1646153cryptic
cuppier1368323c_uppier
drippier1385043drippier
droopier1145573droopier
dropped13329283dropped
dropper12329873dropper
dropping14309283dropping
dropsied1234963dropsied
dropsies1138693dropsies
floppier1554633floppier
floppies1546813floppies
frappe13286953frapp_e
gloppier1354673gloppier
grapple12378003grapple
grippe115310323gripp_e
grippier1355203grippier
gripple12416613gripple
grope84821613gro_p_e
groupies1137523groupies
hippie132811243_hippie
hoppier143110703_hoppier
hopple132910483_hopple
koppies153210013_koppies
loppier11369723_loppier
nappie104112263_nappie
poppied11388983_poppied
poppies102816193_poppies
popple92710983_popple
popsie103013053_popsie
porkpie1544673porkpie
potpie103412433_potpie
preppier1156643preppier
preppies1149683preppies
propane112716153propane
propene112716043propene
propine113020213propine
propone112716303propone
propose112714843propose
propped113311953propped
propping122811673propping
propria1149933propria
prossie91812953prossie
prostie91617743prostie
rappee103618673_rappee
ripple103413913_ripple
roadie72813813_roadie
roofie93411173_roofie
rookie103613263_rookie
roomie83013873_roomie
rope65542913_ro_p_e
ropier84118803_ro_pier
roupier9319493_roupier
scrapie115010943scr_apie
scrappier1544423scrappier
scrapple1434683scrapple
shoppe133110323shopp_e
sloppier1255703sloppier
soppier112711583_soppier
stopple1156583stopple
stroppier1364453stroppier
topple104411323_topple
trippier1246623trippier
trompe105611263tromp_e
trope75725803tro_p_e
trophic14311033trophic
trophied1437643trophied
trophies13413673trophies
tropic103014193tro_pic
tropin83316753tro_pin
tropine93116653tropine
troupe84812433troup_e
whoopie15295933whoopie
yippie13277843_yippie
yuppie13297133_yuppie

Search took 7 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.1531167915.0
2DLD Change Limit1340271926.51620568.9
3Display Results1921920.0802400.0
 (SQL Overall)1786911926.74926476.7
 
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.