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

238 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
crimples1430896(None) 
crimple13408691crimple_
crimpled15366931crimpled
cripples14298401cripples
crumples14348811crumples
rimples113114221_rimples
crimeless1335062crimeless
crimes105521582crim__es
crimped143910762crimp_ed
crimper136510422crimp_er
crimpers14318932crimpers
crimpier14287322crimpier
crimpiest15237182crimpiest
crimps124613452crimp__s
cringles11329462cringles
crinkles14269162crinkles
cripes105120872cri_p_es
cripple13378582cripple_
crippled15336802crippled
crippler14826712crippler
cripplers15314992cripplers
crumbles14329682crumbles
crumple13368362crumple_
crumpled15296872crumpled
dimples122813212_dimples
pimples133012422_pimples
rimple103814582_rimple_
rimpled123311422_rimpled
ripples113513292_ripples
rumples113313132_rumples
simples113014942_simples
tramples122610202tramples
triples94616872tri_ples
wimples143311172_wimples
bedimples1642973bedimples
bepimples1742303bepimples
brambles14308973brambles
brickles162810283brickles
bricoles122610303bricoles
bridles104114473bri_dles
brimless1235273brim_less
brindles113710223brindles
bristles101510433bristles
brittles10178653brittles
carioles10817073cari_oles
chicles143512503chi_cles
chiles115425303chi__les
chimbley2063133chimbley
chimbleys2162233chimbleys
chimblies1845033chimblies
chimeres153511313chimeres
chimes134922573chim__es
chimlas1437453chim_las
chimley1785163chim_ley
chimleys1883633chim_leys
chimps155713663chimp__s
chippies17309763chippies
cimices13279803c_imices
circles1139903c_ircles
citoles9312553c_itoles
climates12311973climates
climaxes1944613climaxes
climes104720003clim__es
compels133210893c_ompels
compiles14311983c_ompiles
complex2037243c_omplex
complies14314523c_omplies
couples115317053c_ouples
crackles164111273crackles
cradles103114133cr_adles
crambes1339963cram_bes
cramboes1436543cramboes
cramped144712183cramp_ed
crampier14288903crampier
crampiest15268623crampiest
crampits1436273crampits
crampons1436643crampons
cramps125615563cramp__s
crankles143510153crankles
crapes104727693cr_ap_es
crappies142911173crappies
creepies1239613creepies
cremates124216003cremates
cremes104517993crem__es
creoles9913323cr_eoles
crepes105419343cr_ep_es
cribbled15305803cribbled
cries75438403cri___es
crime94822693crim__e_
crimine112413473crimine_
criminis12257303criminis
crimmer133310773crim_mer
crimmers14298543crimmers
crimp115615803crimp___
crimping15299783crimping
crimpling1645343crimpling
crimpy15489393crimp__y
crimsons1245633crimsons
cringes103215503cri_nges
cringle103010353cringle_
crinites10612763crinites
crinkle13359413crinkle_
crinkled15357153crinkled
criollos1043713criollos
cripe95521143cri_p_e_
crises84529433cri__ses
crisped124010113crisp_ed
crispen11348203crisp_en
crispens12286253crispens
crisper113511053crisp_er
crispers12309443crispers
crispest12177373crisp_est
crispier12297263crispier
crispiest13197423crispiest
crisply14426523crispl_y
crispness1345313crispness
crisps104411513crisp__s
cropless1237793cr_opless
croppies143111153croppies
croupes114613103croup_es
crumble133410403crumble_
crumbled15357443crumbled
crummies1437643crummies
crumped144311223crump_ed
crumpet133711063crump_et
crumpets14335943crumpets
crumplier1543783crumplier
crumpliest1644123crumpliest
crumply16336093crumpl_y
crumps124514343crump__s
cuittles1045903cuittles
dimple113512793_dimple_
dimpled132810303_dimpled
dribbles13348393dribbles
dripless1135243dri_pless
drizzles17295293drizzles
drumbles13277723drumbles
examples1944313examples
fimbles143510663_fimbles
fipples14298653_fipples
fribbles15287713fribbles
frijoles1834373frijoles
frizzles19297283frizzles
glimpses1343953glimpses
grapples13348123grapples
gribbles13307363gribbles
griddles1145753griddles
grilles83715023gri_lles
grimaces1355383grimaces
grimes94619033grim__es
gripes94619873gri_p_es
grippes124810373gri_ppes
gripple12416613gripple_
gristles9189203gristles
grizzles17286193grizzles
grumbles13288873grumbles
guimpes1245073guimp_es
hirples12149643_hirples
impales113311763__impales
impels10389523__impels
impled113812513__impled
implies11312123__implies
nipples11319663_nipples
orioles7412993ori_oles
pimple123512963_pimple_
pimpled14289193_pimpled
prickles162511093prickles
primages13159273primages
primates121515933primates
primes104225263prim__es
primines123013703primines
primped14479153primp_ed
primps124711823primp__s
primulas1246123primulas
primuses1237083primuses
rambles113118313_rambles
rampoles1238893_rampoles
riddles93215023_riddles
riffles133911163_riffles
rifles94217703_ri_fles
riles55343643_ri__les
rilles64725503_ri_lles
rimes75634543_rim__es
rimless9369363_rim_less
ripes75435773_ri_p_es
ripple103413913_ripple_
rippled123110273_rippled
rippler113210103_rippler
ripplers12337113_ripplers
ripplet113412583_ripplet
ripplets12316733_ripplets
rumbles114018393_rumbles
rumple103913013_rumple_
rumpled123810013_rumpled
rumpless12256543_rumpless
samples112815453_samples
scrambles15146383scrambles
scrapples1534803scrapples
scribbles15184953scribbles
scrimped1555313scrimp_ed
scrimper1455763scrimp_er
scrimpers1554643scrimpers
scrimpier1554243scrimpier
scrimpiest1643753scrimpiest
scrimps13517903scrimp__s
scruples1237433scr_uples
similes92915233_similes
simple104315173_simple_
simpler112910863_simpler
simplest122310223_simplest
simplex18256393_simplex
stipples1247023stipples
swiples12339643swi_ples
swipples1534843swipples
temples112610893_temples
thimbles1536023thimbles
tipples112811253_tipples
trample11299703trample_
trampled13247903trampled
trampler12278013trampler
tramplers13305883tramplers
trembles1237353trembles
trickles143013763trickles
trifles103814823tri_fles
trindles93211683trindles
tripes85324873tri_p_es
triple84215923tri_ple_
tripled104113833tri_pled
triplet94319213tri_plet
triplets103510263tri_plets
triplex16447803tri_plex
trompes114111623tromp_es
uncrumples1652083uncrumples
wimbles143010853_wimbles
wimple133611363_wimple_
wimpled15338823_wimpled
wriggles13286263wriggles
wrinkles15296693wrinkles

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.406440125.6
2DLD Change Limit1461622387.17020385.2
3Display Results2382380.0932559.1
 (SQL Overall)1786912387.66923300.4
 
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.