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 “crumple” 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
crumple1336836(None) 
crimple13408691crimple
crumble133410401crumble
crumpled15296871crumpled
crumples14348811crumples
crumply16336091crumply
rumple103913011_rumple
couple104415962cou_ple
crimpled15366932crimpled
crimples14308962crimples
cripple13378582cripple
crumbled15357442crumbled
crumbles14329682crumbles
crumbly16347522crumbly
crummie1336152crummie
crump115616422crump__
crumped144311222crumped
crumpet133711062crumpet
crumplier1543782crumplier
crumps124514342crump_s
drumble12337892drumble
grumble12349232grumble
rimple103814582_rimple
rumble103718812_rumble
rumpled123810012_rumpled
rumples113313132_rumples
rumply13348572_rumply
scruple1137192scru_ple
trample11299702trample
uncrumple1542332uncrumple
ample94720303__ample
bramble133710033bramble
brumal1049503brumal_
brume95817983brum__e
bumble124216893_bumble
caruncle1244713caruncle
caudle93912913cau_dle
chuckle1836443chuckle
chump145315443chump__
chumped17379493chumped
chumps154313823chump_s
clump115517453clump__
clumped143610663clumped
clumpier1435583clumpier
clumplike1942603clumplike
clumps1215314643clump_s
clumpy15409573clump_y
compel124412893c_ompel
compile13312443c_ompile
complex2037243c_omplex
comply152810383c_omply
coupe96023483cou_p_e
coupled124312673cou_pled
coupler114713013cou_pler
couples115317053cou_ples
couplet114717943cou_plet
crackle153611253crackle
cradle93313163cr_adle
crambe1239073cram_be
cramp115120693cramp__
cramped144712183cramped
crampier14288903crampier
crampit1338863crampit
crampon1336943crampon
cramps125615563cramp_s
crampy154710993cramp_y
crankle133610063crankle
crape96128443cr_ap_e
crappie13298983crappie
creepie1137483creepie
cremate113816183cremate
creme94319323crem__e
creole8913723cr_eole
crepe95520723cr_ep_e
crime94822693crim__e
crimine112413473crimine
crimp115615803crimp__
crimped143910763crimped
crimper136510423crimper
crimpier14287323crimpier
crimps124613453crimp_s
crimpy15489393crimp_y
cringle103010353cringle
crinkle13359413crinkle
cripe95521143cr_ip_e
crippled15336793crippled
crippler14826713crippler
cripples14298403cripples
crisply14426523crisply
croppie13278793croppie
croupe105114433croup_e
crucible1445193crucible
crude86018573cru__de
crudely1336273crudely
cruel74815903cru_el_
crueler939023cru_eler
crueller1056453crueller
cruelly1236553cruelly
cruise84314043cru_ise
cruller968753cru_ller
crumb114313593crum__b
crumbed14378473crumbed
crumber13339643crumber
crumbier1456363crumbier
crumblier1543873crumblier
crumbs12409233crum_bs
crumbum1543743crumbum
crumby15408113crum_by
crummier1435603crummier
crummies1437643crummies
crummy15365893crum_my
crumpets14335943crumpets
crumping15319903crumping
crumpliest1644113crumpliest
crumpling1645323crumpling
crunode1034713crunode
crupper13338563crupper
crural8610633crural_
crusade1036053crusade
cruse75726103cru__se
crusily12199093crusily
cuddle104414533c_uddle
culpae10389263c_ulpae
cumuli1036273c_umuli
cupel9514303c_u_pel
cupule103410723c_upule
curable112414513curable
curdle95514313c_urdle
curule83614123c_urule
cuttle84113893c_uttle
dimple113512793_dimple
drumbled14266033drumbled
drumbles13277723drumbles
drumly1235703drum_ly
drupe85012993dru_p_e
duple85315863_du_ple
example1844283example
frump126912563frump__
frumpier1534173frumpier
frumpily1843323frumpily
frumps13479783frump_s
frumpy16466883frump_y
fumble133214263_fumble
grapple12378003grapple
gripple12416613gripple
grumbled14256753grumbled
grumbler13866683grumbler
grumbles13288873grumbles
grumbly15355403grumbly
grume86218163grum__e
grumose1035723grumose
grump105115313grump__
grumped13337333grumped
grumphie1642763grumphie
grumphy18443623grumphy
grumpier1334803grumpier
grumpily1643463grumpily
grumps114510573grump_s
grumpy14498153grump_y
gruntle8257053gruntle
humble133615053_humble
jumble174012653_jumble
mumble123614343_mumble
octuple1153993octu_ple
pimple123512963_pimple
plumply1634223plumply
plumule1134303plumule
purple102712673_purple
ramble104519973_ramble
rampole1139693_rampole
rimpled123311423_rimpled
rimples113114223_rimples
ripple103413913_ripple
rubble104315673_rubble
ruble74521253_ru_ble
ruckle124414583_ruckle
ruddle83414203_ruddle
ruffle124111673_ruffle
rule49938423_ru__le
rumbled124514593_rumbled
rumbler113514113_rumbler
rumbles114018393_rumbles
rumbly134412163_rumbly
rump86729083_rump__
rumpless12256543_rumpless
rumplier1235303_rumplier
rumps95922293_rump_s
rumpus10458893_rumpus
rundle73214233_rundle
runkle103611543_runkle
rupee7321283_ru_pee
rustle63615413_rustle
rutile65217683_rutile
sample104215013_sample
scramble14177253scramble
scrapple1434683scrapple
scrupled1335813scru_pled
scruples1237433scru_ples
scumble1337013scumble
semple103212753_semple
simple104315173_simple
stumble1147553stumble
supple10410203_supple
temple102811333_temple
trampled13247903trampled
trampler12278003trampler
tramples122610203tramples
tremble1138003tremble
triple84215923tr_iple
trompe105611263tromp_e
truckle13358863truckle
truffle1384893truffle
trump95615123trump__
trumped12439713trumped
trumpet113810723trumpet
trumps104611883trump_s
trundle8307873trundle
tumble103215643_tumble
uncrumpled1742403uncrumpled
uncrumples1652083uncrumples
unrumpled1443673unrumpled
wimple133611363_wimple

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 Limit1340272226.67320085.0
3Display Results2222220.0802775.0
 (SQL Overall)1786912226.90625874.7
 
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.