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

471 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
crappers14401102(None) 
cappers134419401c_appers
clappers143310831clappers
crapper133913191crapper_
croppers143311481croppers
cruppers14317321cruppers
rappers113618441_rappers
scrappers1545861scrappers
trappers123711041trappers
wrappers15306931wrappers
campers134220292c_ampers
capers105428142c_a_pers
capper124421982c_apper_
carpers114521252c_arpers
champers173311622champers
chapters154012132chapters
chippers173510882chippers
choppers174110462choppers
clampers143211892clampers
clapper134011862clapper_
claspers124410912claspers
clippers14368842clippers
coappears1542952coappears
coppers133519752c_oppers
crabbers14358752crabbers
crackers164111722crackers
cradlers11309202cradlers
crafters13419952crafters
crammers14369352crammers
crapes104727692cra_pe_s
crapped143912622crappe_d
crappier14288132crappier_
crappies142911152crappies
crashers134013232crashers
craters95021892cra_ters
cravers124416562cra_vers
crawlers13309012crawlers
creepers12318632creepers
crimpers14318932crimpers
cripplers15314992cripplers
crispers12309432crispers
cropper133312962cropper_
crupper13338562crupper_
cuppers133712212c_uppers
drapers105313352dra_pers
drippers13327942drippers
droppers13318602droppers
flappers15388382flappers
frappes14328382frappe_s
grapplers14274302grapplers
graspers11338402graspers
grippers13358132grippers
knappers16315642knappers
lappers113717462_lappers
mappers133313782_mappers
nappers114214862_nappers
rapers84327182_ra_pers
rapiers95012872_rapiers
rappees113611452_rappees
rappels11448802_rappels
rapper104621572_rapper_
raspers94415922_raspers
rippers114115032_rippers
sappers113518902_sappers
scrapers125510532scra_pers
scrapper1466972scrapper_
slappers123710942slappers
snappers123510172snappers
strappers1346742strappers
swappers15358082swappers
tappers113416542_tappers
trampers123210392trampers
trapper113912802trapper_
trippers123210162trippers
whappers18276742whappers
wrapper14368332wrapper_
yappers144012252_yappers
zappers203911632_zappers
adapters1136103adapters
apers76629133__a_pers
appears11308953__appears
appels104312793__appels
aspers86220313__aspers
boppers133911923_boppers
bracers114616703bra_cers
braggers12327903braggers
braiders114110573braiders
branders114313093branders
branners104010923branners
brasiers103710513brasiers
bravers124715523bra_vers
brawlers13408643brawlers
brayers124511903bra_yers
brazers184513943bra_zers
braziers19397193braziers
cabers105023923c_a_bers
cablers114416713c_ablers
cadgers114712003c_adgers
cagers95624193c_a_gers
cahiers123510673c_ahiers
calipers1249443calipers
calkers134414693c_alkers
callers94221963c_allers
cambers134017443c_ambers
camper124722213c_amper_
cancers114018583c_ancers
caners84629203c_a_ners
cankers134418753c_ankers
canners93822663c_anners
canoers94318373c_anoers
canters94827733c_anters
caper94831623c_a_per_
caperers122611723c_aperers
capes95441923c_a_pe_s
capless114312763c_apless
caplets114914523c_aplets
capped134721853c_appe_d
captors113914983c_aptors
carders104820353c_arders
careers95218783c_areers
carers85133963c_a_rers
carolers103314173carolers
carpels115315463c_arpels
carper104923633c_arper_
carpets113915333c_arpets
carriers103614203carriers
carters95327253c_arters
cartoppers1643743cartoppers
carvers124817543c_arvers
casters94729903c_asters
caters85336503c_a_ters
catnappers1682763catnappers
causers94014793c_ausers
cavers115026843c_a_vers
chafers154512743cha_fers
chaffers19378003chaffers
chambers173410623chambers
chamfers18409223chamfers
champer163813413champer_
chancers154313493chancers
changers144313203changers
chanters134016743chanters
chapels14429153cha_pels
chapes135421873cha_pe_s
chapiters1635203chapiters
chaplets1556883chaplets
chapped172711443chappe_d
chappies172610093chappies
chapter144213853chapter_
chargers144011323chargers
charmers154211333charmers
charters134115583charters
chasers123714923cha_sers
chatters134213953chatters
chaufers16347303chaufers
chawers154412053cha_wers
cheepers15329013cheepers
chipper163912583chipper_
chirpers15358133chirpers
chompers17369593chompers
chopper163611893chopper_
ciphers14379993c_iphers
clabbers14359903clabbers
clackers163911703clackers
claimers12298743claimers
clambers144211293clambers
clammers143510693clammers
clamper134012993clamper_
clangers114312343clangers
clapped143511173clappe_d
claquers19226203claquers
clashers134213993clashers
clasper113811863clasper_
classers104111833classers
clatters103313913clatters
clavers124314903cla_vers
claviers1367103claviers
clawers123910973cla_wers
clipper133710323clipper_
coachers154312303coachers
coalers94419353coa_lers
coappear1442893coappear
coasters104317333coasters
coaters93525793coa_ters
coaxers164311083coa_xers
compeers143410013compeers
coopers114019483c_oopers
copers104629843c__opers
copiers114215963c_opiers
copper124321893c_opper_
copperas14308573c_opperas
coppery16409393c_oppery
copters113621283c_opters
couplers123311323couplers
crabber133810733crabber_
cracker153114173cracker_
cradler102910513cradler_
cradles103114133cradle_s
crafter124111333crafter_
crakes124921813cra_ke_s
crambes1339963crambe_s
crammer134010963crammer_
cramped144712183crampe_d
crampier14288903crampier_
crampits1436273crampits
crampons1436643crampons
cramps125615563cramp__s
cranes84330753cra_ne_s
cranker133612793cranker_
crape96128443cra_pe__
craped116120523cra_pe_d
crapolas1247403crapolas
crappie13298983crapp_ie
crappiest15267263crappiest
crapping153911453crapping
crappy15446803crapp__y
craps95328643cra_p__s
crases85532313cra_se_s
crasher124616163crasher_
crashes124618403crashe_s
crasser94114343crasser_
crater85026643cra_ter_
crates85736063cra_te_s
cravens124010123cra_vens
craver114618473cra_ver_
craves115825393cra_ve_s
crawler123510463crawler_
crayoners1444503crayoners
crazes174720133cra_ze_s
crazier183610743crazier_
crazies183413853crazie_s
creamers124111313creamers
creasers103612843creasers
creeper11339983creeper_
crepes105419343cr_epe_s
crepier1139743crepier_
cribbers14306443cribbers
criers83918583cr__iers
crimmers14298543crimmers
crimper136510423crimper_
cringers112511873cringers
cripes105120873cr_ipe_s
crippler14826713crippler_
cripples14298403cripples
crispens12286253crispens
crisper113511053crisper_
critters103511323critters
croakers14288523croakers
crofters13358903crofters
crooners103911393crooners
cropless1237793cropless
cropped143812063croppe_d
croppies143111133croppies
crosiers103312063crosiers
crossers103912703crossers
croupes114613103croupe_s
croupiers1334653croupiers
crowders14398813crowders
crowers124614903cr_owers
crowners133710753crowners
crozers184111083cr_ozers
croziers19287003croziers
cruisers10438273cruisers
crullers1047303crullers
crumbers14338243crumbers
crumpets14335943crumpets
crushers134010093crushers
cupper124313863c_upper_
curlpapers1641433curlpapers
cyphers17316753c_yphers
dampers123915693_dampers
dapper114016633_dapper_
diapers104713913dia_pers
didappers1543173didappers
dippers123615183_dippers
drafters12338523drafters
draggers11357393draggers
drainers92811253drainers
draper94315693dra_per_
drapery13387943dra_pery
drapes95419653dra_pe_s
drawers113610073dra_wers
drawlers12307313drawlers
dripper12349233dripper_
dropper12329873dropper_
entrappers1444183entrappers
erasers74413943era_sers
flapper14359203flapper_
flippers15338003flippers
floppers15337463floppers
framers125113823fra_mers
frankers15348353frankers
frappe13286953frappe__
frapped15318853frappe_d
fraters103517213fra_ters
frippery1832953frippery
gapers94520473_ga_pers
gaspers105014133_gaspers
gawpers13448313_gawpers
gippers123212083_gippers
grabbers13337883grabbers
graders94716013gra_ders
grafters12409193grafters
grainers93012073grainers
grangers103011973grangers
granters93614143granters
grapery13457953gra_pery
grapes95123123gra_pe_s
grapier103712603grapier_
grapnels1134393grapnels
grappas12357103grapp_as
grappler13336193grappler_
grapples13348123grapples
grasper10389793grasper_
graters85419743gra_ters
graupels1133103graupels
gravers114515273gra_vers
grazers175112453gra_zers
graziers18387123graziers
gripers104011463gr_ipers
gripper124410713gripper_
grippes124810373grippe_s
gropers104813853gr_opers
groupers11358643groupers
gyppers15235503_gyppers
hampers143616953_hampers
happens14359173_happens
harpers124916203_harpers
heapers123616673hea_pers
hoppers143115143_hoppers
japers154616173_ja_pers
jaspers164310463_jaspers
kippers153211433_kippers
knapper15387153knapper_
kraters114212343kra_ters
lampers113817333_lampers
lapper104319953_lapper_
lappets11329123_lappets
lapsers93911053_lapsers
leapers93716663lea_pers
lippers113416443_lippers
loppers113014103_loppers
mapper124516093_mapper_
moppers133412463_moppers
napper103718283_napper_
nappes104515623_nappe_s
nippers113012623_nippers
pampers133615933_pampers
papers105125323_pa_pers
paupers114311073_paupers
peppers103311443_peppers
poppers103414863_poppers
praisers103410833praisers
prancers123210333prancers
praters94921653pra_ters
prawners1346003prawners
prayers124212853pra_yers
propers113619033pr_opers
prospers123012263prospers
quippers2184813quippers
racers84725433_ra_cers
rackers134320453_rackers
rafters103715633_rafters
raiders84615143_raiders
railers74420663_railers
raisers73617393_raisers
rakers104123573_ra_kers
rammers113715043_rammers
rangers83621043_rangers
rankers113217463_rankers
ranters73323643_ranters
raper74932753_ra_per_
rapes75740723_ra_pe_s
raphes115117453_raphe_s
rapier84019993_rapier_
rapped114122683_rappe_d
rappee103618673_rappe_e
rappel104211953_rappe_l
rappen103512713_rappe_n
rapport11311223_rapport
rapports1245963_rapports
raptors94213353_raptors
rasers64526783_ra_sers
rashers104020913_rashers
rasper83917333_rasper_
rasters74629023_rasters
raters63936583_ra_ters
ratters74422473_ratters
ravers94628183_ra_vers
razers154919613_ra_zers
reapers93520453_reapers
reappears1342853reappears
repapers1258833_repapers
ripper103518653_ripper_
ripplers12337113_ripplers
rompers113412243_rompers
ropers84325903_r_opers
sapper103822353_sapper_
scalpers123710863scalpers
scampers143611033scampers
scarpers124712513scarpers
scaupers12378173scaupers
schappes1736033schappe_s
schnappers1942143schnappers
scraper114513423scra_per_
scrapes116217663scra_pe_s
scrapies124612473scrapie_s
scrapped1556533scrappe_d
scrappier1544423scrappier_
scrapples1534793scrapples
scrawlers1434753scrawlers
scrimpers1554643scrimpers
scripters13116683scripters
scuppers1446543scuppers
shapers124016893sha_pers
sharpers133810943sharpers
shippers153012313shippers
shoppers153010763shoppers
sippers113117753_sippers
skippers16318203skippers
slapper113512463slapper_
slippers123711233slippers
snapper113512073snapper_
snippers12299723snippers
soapers93715923soa_pers
stampers124211603stampers
staplers103111203staplers
steppers12289283steppers
stoppers123910593stoppers
strapper1258093strapper_
strippers1355773strippers
stroppers1356713stroppers
suppers113314703_suppers
swampers15317473swampers
swapper14359703swapper_
tampers113516743_tampers
tapers84025813_ta_pers
tapper104419613_tapper_
tappets113610013_tappets
tarpapers1344273tarpapers
tippers113414353_tippers
toppers113914603_toppers
tracers94917843tra_cers
trackers143512853trackers
traders84316953tra_ders
trailers82912923trailers
trainers83114643trainers
tramper113812163tramper_
tramplers13305883tramplers
trapes85024463tra_pe_s
trappean1244393trappean
trapped124512213trappe_d
trappous1246023trappous
trashers113013643trashers
trawlers113310203trawlers
tripper113711923tripper_
trippets12357423trippets
troopers10289443troopers
troupers10359443troupers
uppers102912293__uppers
vampers143111623_vampers
warpers123413583_warpers
whapper17348273whapper_
whippers18329043whippers
whoppers18297533whoppers
wrapped15338023wrappe_d
yapper133714513_yapper_
yaupers12337663_yaupers
yawpers15346853_yawpers
zapper193414023_zapper_
zippers203310383_zippers

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.423422437.4
2DLD Change Limit1461624717.78018786.9
3Display Results4714710.1732722.5
 (SQL Overall)1786914718.37621333.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.