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

201 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
crumpled1529687(None) 
crimpled15366931crimpled
crumbled15357441crumbled
crumped144311221crump_ed
crumple13368361crumple_
crumples14348811crumples
rumpled123810011_rumpled
chumped17379492chump_ed
clumped143610662clump_ed
coupled124312672cou_pled
cramped144712182cramp_ed
crimped143910762crimp_ed
crimple13408692crimple_
crimples14308962crimples
crippled15336792crippled
crumbed14378472crum_bed
crumble133410402crumble_
crumbles14329682crumbles
crumpet133711062crump_et
crumplier1543782crumplier
crumply16336092crumpl_y
drumbled14266032drumbled
grumbled14256752grumbled
grumped13337332grump_ed
rimpled123311422_rimpled
rumbled124514592_rumbled
rumple103913012_rumple_
rumples113313132_rumples
scrupled1335822scru_pled
trampled13247902trampled
trumped12439712trump_ed
uncrumpled1742402uncrumpled
unrumpled1443672unrumpled
brambled15316733brambled
bumbled144113043_bumbled
bumped134414003_bump_ed
camped134720233c_amp_ed
champed174111483champ_ed
chomped17329773chomp_ed
chuckled2045163chuckled
chummed17396443chum_med
clamped144012043clamp_ed
clomped14398973clomp_ed
clumpier1435583clumpier
coempted1535333coempted
comped135919873c_omp_ed
compiled1537813c_ompiled
complex2037243c_omplex
complied1539673c_omplied
compted143813523c_ompted
couped115019313cou_p_ed
couple104415963cou_ple_
coupler114713013cou_pler
couples115317053cou_ples
couplet114717943cou_plet
craaled10339423cr_aaled
crackled17428863crackled
cradled113410813cr_adled
crammed143710123cram_med
crampier14288903crampier
crankled15408153crankled
craped116120523cr_ap_ed
crapped143912623cr_apped
crawled133710403cr_awled
creeled104012013cr_eeled
creeped12329713creep_ed
cremated133412963cremated
creneled11326893creneled
creped114115703cr_ep_ed
cribbled15305803cribbled
crimper136510423crimp_er
crimpier14287323crimpier
crinkled15357153crinkled
cripple13378583cripple_
crippler14826713crippler
cripples14298403cripples
crisped124010103crisp_ed
cropped143812063cr_opped
crudded1235733cru_dded
crueler939023cru_eler
crueller1056453crueller
cruised103710213cru_ised
cruller968753cru_ller
crumber13339643crum_ber
crumbier1456363crumbier
crumblier1543873crumblier
crumbly16347523crumbl_y
crummie1336153crummie_
crummier1435603crummier
crummies1437643crummies
crump115616423crump___
crumpets14335943crumpets
crumping15319903crumping
crumpliest1644123crumpliest
crumpling1645323crumpling
crumps124514343crump__s
crunched16328163crunched
crupper13338563cru_pper
crusaded1244233crusaded
crushed134111963cru_shed
crusted103712753cru_sted
crutched16307463crutched
cuddled124110763c_uddled
culled94022473c_u_lled
cupeled1257793c_upeled
cupped134413983c_u_pped
curdled113910663c_urdled
curled95021653c_u_rled
cusped114312043c_usp_ed
cuttled10319933c_uttled
dimpled132810303_dimpled
drumble12337893drumble_
drumbles13277723drumbles
drummed13306323drum_med
dumped123814493_dump_ed
erupted10207163eru_pted
exampled2043353exampled
flumped15377713flump_ed
frumpier1534173frumpier
fumbled153710493_fumbled
grappled14336093grappled
grueled937133gru_eled
gruelled1034893gruelled
grumble12349233grumble_
grumbler13866683grumbler
grumbles13288873grumbles
grumpier1334803grumpier
gruntled10274943gruntled
harumphed2041543harumphed
humbled153711813_humbled
humped144015243_hump_ed
humphed1835423_humphed
impled113812513__impled
jumbled19379963_jumbled
jumped183511553_jump_ed
lumped114216963_lump_ed
mumbled143010763_mumbled
mumped133813163_mump_ed
octupled1343503octu_pled
pimpled14289193_pimpled
plumped14318643plump_ed
primped14479153primp_ed
prompted1536903prompted
pumped133915563_pump_ed
purpled12299783_purpled
rambled123913523_rambled
ramped114617903_ramp_ed
repled93319783_r_epled
rimple103814583_rimple_
rimples113114223_rimples
rippled123110273_rippled
romped114513653_romp_ed
rubbled124611623_rubbled
ruckled144111033_ruckled
ruddled103010873_ruddled
ruffled14369153_ruffled
ruled65822523_ru__led
rumbaed12287493_rumbaed
rumble103718813_rumble_
rumbler113514113_rumbler
rumbles114018393_rumbles
rumored1046643_rumored
rumpless12256543_rumpless
rumplier1235303_rumplier
rumply13348573_rumpl_y
runkled12399013_runkled
rustled83311323_rustled
sampled123410793_sampled
scrambled16164813scrambled
scrimped1555313scrimp_ed
scrummed1554313scrum_med
scruple1137193scru_ple_
scruples1237433scru_ples
scumbled1535053scumbled
slumped123710153slump_ed
stumbled1335623stumbled
stumped124210153stump_ed
suppled1248463_suppled
templed12278563_templed
thumped15387413thump_ed
trameled11309073trameled
tramped124312433tramp_ed
trample11299703trample_
trampler12278013trampler
tramples122610203tramples
trembled1335253trembled
tripled104113833tr_ipled
triumphed1741943triumphed
tromped124210293tromp_ed
truckled15327313truckled
truffled1563993truffled
trumpet113810723trump_et
trumpeted1443053trumpeted
trundled10306393trundled
tumbled123412243_tumbled
tumped114216233_tump_ed
umped104717273__ump_ed
uncrumple1542333uncrumple_
uncrumples1652083uncrumples
whumped18335633whump_ed
wimpled15338823_wimpled

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.423422437.4
2DLD Change Limit1461622017.45319611.2
3Display Results2012010.0802512.5
 (SQL Overall)1786912017.95622459.9
 
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.