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

222 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
crumples1434881(None) 
crimples14308961crimples
crumbles14329681crumbles
crumple13368361crumple_
crumpled15296871crumpled
rumples113313131_rumples
couples115317052cou_ples
crimple13408692crimple_
crimpled15366932crimpled
cripples14298402cripples
crumble133410402crumble_
crumbled15357442crumbled
crummies1437642crummies
crumped144311222crump_ed
crumpet133711062crump_et
crumpets14335942crumpets
crumplier1543782crumplier
crumpliest1644122crumpliest
crumply16336092crumpl_y
crumps124514342crump__s
drumbles13277722drumbles
grumbles13288872grumbles
rimples113114222_rimples
rumbles114018392_rumbles
rumple103913012_rumple_
rumpled123810012_rumpled
rumpless12256542_rumpless
scruples1237432scru_ples
tramples122610202tramples
uncrumples1652082uncrumples
brambles14308973brambles
brumbies1436533brumbies
brumes106417073brum__es
bumbles134016843_bumbles
caruncles1345003caruncles
caudles103912813cau_dles
caules85927253cau__les
chuckles1936803chuckles
chumped17379493chump_ed
chumps154313823chump__s
clumped143610663clump_ed
clumpier1435583clumpier
clumpiest1535343clumpiest
clumps1215314643clump__s
compels133210883c_ompels
compiles14311983c_ompiles
complex2037243c_omplex
complies14314523c_omplies
coupes105022523cou_p_es
couple104415963cou_ple_
coupled124312673cou_pled
coupler114713013cou_pler
couplers123311323cou_plers
couplet114717943cou_plet
couplets12389873cou_plets
crackles164111273crackles
cradles103114133cr_adles
crambes1339963cram_bes
cramboes1436543cramboes
cramped144712183cramp_ed
crampier14288903crampier
crampiest15268613crampiest
crampits1436273crampits
crampons1436643crampons
cramps125615563cramp__s
crankles143510153crankles
crapes104727693cr_ap_es
crappies142911153crappies
creepies1239613creepies
cremates124216003cremates
cremes104517993crem__es
creoles9913323cr_eoles
crepes105419343cr_ep_es
crimeless1335063crimeless
crimes105521583crim__es
crimped143910763crimp_ed
crimper136510423crimp_er
crimpers14318933crimpers
crimpier14287323crimpier
crimpiest15237183crimpiest
crimps124613453crimp__s
cringles11329463cringles
crinkles14269163crinkles
cripes105120873cr_ip_es
cripple13378583cripple_
crippled15336793crippled
crippler14826713crippler
cripplers15314993cripplers
cropless1237793cr_opless
croppies143111133croppies
croupes114613103croup_es
cruces105117543cru__ces
crucibles1543743crucibles
crudes96218623cru__des
crudites1137763crudites
crueler939023cru_eler
cruelest1059183cru_elest
crueller1056453crueller
cruellest1155583cruellest
cruises93514443cru_ises
cruller968753cru_ller
crullers1047303cru_llers
crumbed14378473crum_bed
crumber13339643crum_ber
crumbers14338243crumbers
crumbier1456363crumbier
crumbiest1536253crumbiest
crumblier1543873crumblier
crumbliest1643903crumbliest
crumbly16347523crumbl_y
crumbs12409233crum__bs
crumbums1642733crumbums
crummie1336153crummie_
crummier1435603crummier
crummiest1545563crummiest
crump115616423crump___
crumping15319903crumping
crumpling1645323crumpling
crunches153711353crunches
crunodes1144973crunodes
crupper13338563cru_pper
cruppers14317323cruppers
crusades1146333crusades
cruses88127713cru__ses
crushes124215133cru_shes
crustless1155403crustless
crutches15359593crutches
cruxes154911563cru__xes
cuddles114014093c_uddles
cumulus1135453c_umulus
cupels10310203c_u_pels
cupules113210263c_upules
curdles103814573c_urdles
cuttles93613923c_uttles
dimples122813213_dimples
drumble12337893drumble_
drumbled14266033drumbled
drupes94912653dru_p_es
examples1944313examples
frumpier1534173frumpier
frumpiest1634543frumpiest
frumps13479783frump__s
fumbles143514413_fumbles
grapples13348123grapples
grumble12349233grumble_
grumbled14256753grumbled
grumbler13866683grumbler
grumblers14245023grumblers
grumes94415553grum__es
grumped13337333grump_ed
grumphies1743653grumphies
grumpier1334803grumpier
grumpiest1435023grumpiest
grumps114510573grump__s
gruntles9287233gruntles
humbles143215803_humbles
humpless15226333_humpless
jumbles183013323_jumbles
mumbles133014433_mumbles
numbles113814273_numbles
octuples1244133octu_ples
pimples133012423_pimples
plumules1234663plumules
pumpless14236373_pumpless
purples112712823_purples
rambles113118313_rambles
rampoles1238893_rampoles
rimple103814583_rimple_
rimpled123311423_rimpled
ripples113513293_ripples
rubbles113715113_rubbles
rubles83921703_ru_bles
ruckles133414603_ruckles
ruddles92813873_ruddles
ruffles133512273_ruffles
rules55234253_ru__les
rumble103718813_rumble_
rumbled124514593_rumbled
rumbler113514113_rumbler
rumblers123610743_rumblers
rummies113212793_rummies
rumplier1235303_rumplier
rumpliest1345313_rumpliest
rumply13348573_rumpl_y
rumps95922293_rump__s
rumpus10458893_rump_us
rumpuses1235163_rumpuses
rundles83214713_rundles
runkles114111943_runkles
rupees8312573_ru_pees
rustles73416413_rustles
rutiles74315843_rutiles
samples112815453_samples
scrambles15146383scrambles
scrapples1534793scrapples
scruple1137193scru_ple_
scrupled1335823scru_pled
scumbles1447023scumbles
simples113014943_simples
stumbles1237493stumbles
supples11511283_supples
temples112610893_temples
trample11299703trample_
trampled13247903trampled
trampler12278013trampler
tramplers13305883tramplers
trembles1237353trembles
triples94616873tr_iples
trompes114111623tromp_es
truckles14319383truckles
truffles1485593truffles
trumped12439713trump_ed
trumpet113810723trump_et
trumpets12315573trumpets
trumps104611883trump__s
trundles9278483trundles
tumbles113816023_tumbles
umbles103817493__umbles
uncrumple1542333uncrumple_
uncrumpled1742403uncrumpled
unrumpled1443673unrumpled
wimples143311173_wimples

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.1561145455.1
2DLD Change Limit1461622226.78321548.3
3Display Results2222220.0932387.1
 (SQL Overall)1786912227.03225411.1
 
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.