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

398 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
crimpers1431893(None) 
crimmers14298541crimmers
crimper136510421crimper_
crispers12309431crispers
scrimpers1554631scrimpers
brimmers14287072brimmers
campers134220282c_ampers
champers173311612champers
chimers144515132chim_ers
chippers173510872chippers
chirpers15358132chirpers
chompers17369572chompers
clampers143211882clampers
climbers14318402climbers
clippers14368832clippers
crammers14369342crammers
crappers144011022crappers
creepers12318622creepers
cribbers14306442cribbers
criers83918582cri__ers
crimes105521582crim_e_s
crimmer133310772crimmer_
crimped143910762crimpe_d
crimpier14287322crimpier_
crimples14308962crimples
crimps124613452crimp__s
cringers112511872cringers
cripes105120872cri_pe_s
cripplers15314992cripplers
crispens12286252crispens
crisper113511052crisper_
critters103511312critters
croppers143311482croppers
crumbers14338222crumbers
crumpets14335942crumpets
cruppers14317312cruppers
drippers13327932drippers
gripers104011462gri_pers
grippers13358122grippers
krimmers16315672krimmers
limpers113815222_limpers
primers114215672prim_ers
rimers84522552_rim_ers
rimmers113812882_rimmers
rippers114115022_rippers
rompers113412242_rompers
scrimper1455752scrimper_
shrimpers1633812shrimpers
simpers113014112_simpers
trampers123210372trampers
trimers94615142trim_ers
trimmers12288912trimmers
trippers123210152trippers
whimpers18276612whimpers
aimers84621913_aim_ers
armers85520273ar_m_ers
armigers1135703armigers
bribers114111493bri_bers
bridlers11359183bridlers
briefers1335143briefers
briers85319733bri__ers
brimless1235273brimless
brimmer13348803brimmer_
briners94315633bri_ners
bringers112811073bringers
bumpers133912053_bumpers
calipers1249443calipers
cambers134017433c_ambers
camper124722213c_amper_
capers105428133c__apers
cappers134419403c_appers
carpers114521253c_arpers
ceilers93912533cei_lers
chambers173410613chambers
chamfers18409213chamfers
champer163813403champer_
cheepers15329013cheepers
chiders135312943chi_ders
chiggers1535553chiggers
chillers133710913chillers
chimaera1564913chimaera
chimaeras1664553chimaeras
chimars144010573chim_ars
chimer135517203chim_er_
chimera14389263chim_era
chimeras15388813chim_eras
chimere144010633chim_ere
chimeres153511303chim_eres
chimes134922573chim_e_s
chimleys1883633chimleys
chimneys1883643chimneys
chimps155713663chimp__s
chipper163912583chipper_
chirper14359963chirper_
chitters133711163chitters
chomper163810073chomper_
choppers174110453choppers
ciders94620083c_i_ders
cinders104617753c_inders
ciphers14379983c_iphers
circlers1235343circlers
citers85022973c_i_ters
cithers124315753c_ithers
claimers12298743claim_ers
clambers144211283clambers
clammers143510683clammers
clamper134012993clamper_
clappers143310833clappers
claspers124410913claspers
clickers163910203clickers
climber13449133climber_
climes104720003clim_e_s
clingers113810653clingers
clinkers14339833clinkers
clipper133710323clipper_
clivers123411753cli_vers
clumbers143910393clumbers
coilers93619903coi_lers
coiners93620753coi_ners
coinfers13349503coinfers
cointers103616403cointers
combers134516613c_ombers
comers105328083c_om_ers
compeers143410013c_ompeers
compels133210883c_ompels
compere134616623c_ompere
comperes143217973c_omperes
coopers114019483c_oopers
copers104629843c__opers
coppers133519753c_oppers
crabbers14358743crabbers
crackers164111723crackers
cradlers11309183cradlers
crafters13419943crafters
crambes1339953crambe_s
crammer134010963crammer_
cramped144712183crampe_d
crampier14288903crampier_
crampits1436273crampits
crampons1436643crampons
cramps125615563cramp__s
crapes104727693cr_ape_s
crapper133913193crapper_
crashers134013223crashers
craters95021883cr_aters
cravers124416543cr_avers
crawlers13309003crawlers
creamers124111293creamers
creasers103612813creasers
creeper11339973creeper_
cremes104517993crem_e_s
crepes105419343cr_epe_s
cribber13367663cribber_
crickets16418123crickets
crier74724463cri__er_
cries75438403cri__e_s
crime94822693crim_e__
crimeless1335063crimeless
criminis12257303criminis
crimp115615803crimp___
crimpiest15237183crimpiest
crimping15299783crimping
crimple13408693crimp_le
crimpled15366933crimpled
crimpy15489393crimp__y
crimsons1245633crimsons
cringer103514243cringer_
cringes103215503cringe_s
cripe95521143cri_pe__
crippler14826713crippler_
cripples14298403cripples
crises84529433cri_se_s
crisped124010103crispe_d
crispen11348203crispe_n
crispest12177373crispest
crispier12297253crispier_
crispness1345303crispness
crisps104411513crisp__s
critter94113033critter_
critturs10374593critturs
croakers14288503croakers
crofters13358893crofters
crooners103911393crooners
cropper133312963cropper_
crosiers103312053crosiers
crossers103912693crossers
croupes114613103croupe_s
croupiers1334633croupiers
crowders14398793crowders
crowers124614893cr_owers
crowners133710743crowners
crozers184111083cr_ozers
croziers19287003croziers
cruisers10438263cruisers
crullers1047293crullers
crumber13339643crumber_
crumped144311223crumpe_d
crumpet133711063crumpe_t
crumples14348813crumples
crumps124514343crump__s
crupper13338563crupper_
crushers134010083crushers
cumbers134515393c_umbers
cummers133713473c_ummers
cuppers133712193c_uppers
dampers123915693_dampers
diapers104713893_diapers
dimers94321093_dim_ers
dimmers123811563_dimmers
dippers123615173_dippers
drapers105313353dr_apers
driers74516733dri__ers
drifters12417913drifters
drillers9429713drillers
drinkers13277823drinkers
dripper12349223dripper_
drivers114412793dri_vers
droppers13318593droppers
drummers13316163drummers
dumpers123412663_dumpers
epimers11109493epim_ers
firmers124711443firm_ers
flippers15337993flippers
framers125113823fram_ers
friers94718933fri__ers
frillers11349863frillers
frippery1832953frippery
friskers15337373friskers
fritters113810783fritters
frizers19329553fri_zers
frizzers19335103frizzers
gippers123212073_gippers
glimmers13396153glimmers
glimpsers1442193glimpsers
graspers11338393graspers
gridders11286293gridders
grievers1255473grievers
grifters12389233grifters
grillers93810803grillers
grimacers1463553grimacers
grimes94619033grim_e_s
grimier103210433grimier_
grimmer123510093grimmer_
grimness1175993grimness
grinders103410423grinders
grinners9288043grinners
griper94114613gri_per_
gripes94619873gri_pe_s
gripper124410713gripper_
grippes124810373grippe_s
gristers94013403gristers
gritters94210633gritters
gropers104813853gr_opers
groupers11358633groupers
guimpes1245073guimpe_s
hampers143616943_hampers
humpers142713523_humpers
impels10389513__impels
jimper17389863_jimper_
jumpers18399843_jumpers
kippers153211423_kippers
krimmer15376873krimmer_
lampers113817333_lampers
limbers113614723_limbers
limmers113413083_limmers
limners93311553_limners
limper104117853_limper_
limpets11329783_limpets
lippers113416433_lippers
lispers94514323_lispers
lorimers1036613lorim_ers
lumpers113514483_lumpers
maimers113813043maim_ers
mimers105520183_mim_ers
mumpers133311363_mumpers
nippers113012613_nippers
ormers84316143or_m_ers
pampers133615933_pampers
pipers104318663_pi_pers
plumpers14357293plumpers
premiers122911653premiers
pricers113915063pri_cers
prickers163710673prickers
priers84521193pri__ers
primer105118683prim_er_
primero11368923prim_ero
primeros12336883prim_eros
primes104225263prim_e_s
primmer134310163primmer_
primness1276763primness
primped14479153primpe_d
primps124711823primp__s
prinkers143010383prinkers
printers103214903printers
prizers183911843pri_zers
prompters1537533prompters
propers113619033pr_opers
prospers123012253prospers
pumpers133113673_pumpers
quippers2184803quippers
rammers113715043_rammers
rapers84327183_r_apers
rappers113618443_rappers
raspers94415913_raspers
reapers93520453_reapers
ribbers113913183_ribbers
ribiers9319753_ribiers
ricers84120993_ri_cers
ridders93612483_ridders
riders74123903_ri_ders
rievers104311453_rievers
riflers103512193_riflers
riggers93613833_riggers
rimer75429243_rim_er_
rimes75634543_rim_e_s
rimier83916263_rimier_
rimless9369363_rimless
rimmer103516033_rimmer_
rimples113114223_rimples
ringers83922943_ringers
rinsers73815743_rinsers
rioters73615503_rioters
ripens85012173_ri_pens
riper74328403_ri_per_
ripes75435773_ri_pe_s
ripper103518653_ripper_
ripplers12337113_ripplers
risers64624783_ri_sers
riskers114011993_riskers
ritters74020613_ritters
rivers94626543_ri_vers
romper104213683_romper_
ropers84325903_r_opers
rummers113513653_rummers
scampers143611033scampers
scrapers125510513scr_apers
scrappers1545843scrappers
scribers12307953scri_bers
scrimped1555313scrimpe_d
scrimpier1554243scrimpier_
scrimps13517903scrimp__s
scripters13116673scripters
shimmers15269413shimmers
shippers153012303shippers
shrimper1544413shrimper_
simmers113314613_simmers
simper103616293_simper_
sippers113117743_sippers
skimmers16296453skimmers
skippers16318193skippers
slimmers12369633slimmers
slippers123711223slippers
snipers93311763sni_pers
snippers12299713snippers
stampers124211593stampers
stompers123610033stompers
stripers103911583stri_pers
strippers1355753strippers
stumpers12318313stumpers
swampers15317473swampers
swimmers15276693swimmers
tampers113516743_tampers
tempers113513013_tempers
thumpers15365713thumpers
timbers113111833_timbers
timers84420993_tim_ers
tippers113414343_tippers
tramper113812153tramper_
tramplers13305873tramplers
trappers123711023trappers
trickers143812813trickers
triers64321523tri__ers
triflers113110213triflers
triggers10257843triggers
trillers83613483trillers
trimer85717153trim_er_
trimeters1139203trimeters
trimmer113610833trimmer_
trimness1067563trimness
tripes85324873tri_pe_s
tripper113711923tripper_
trippets12357423trippets
trompes114111623trompe_s
troopers10289423troopers
troupers10359423troupers
trumpery1533613trumpery
trumpets12315573trumpets
vampers143111623_vampers
vipers114914533_vi_pers
whimper17297723whimper_
whippers18329033whippers
whispers16266993whispers
wipers115416083_wi_pers
wrappers15306933wrappers
wringers123110073wringers
writers105513493wri_ters
writhers14398983writhers
zippers203310373_zippers

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.1701051123.5
2DLD Change Limit1461623986.78321548.3
3Display Results3983980.1562551.3
 (SQL Overall)1786913987.10925135.9
 
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.