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

170 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
freckled1810444(None) 
freckle16106641freckle_
freckles17126381freckles
crackled17428862crackled
flecked17358072fleck_ed
freaked15399702freak_ed
frecklier1842992frecklier
freckly19124592freckl_y
frocked17439332frock_ed
heckled17318462_heckled
keckled13376502_keckled
prickled17358072prickled
recked134821802_reck_ed
ruckled144111032_ruckled
speckled17255832speckled
trickled152610432trickled
truckled15327312truckled
wrecked17418332wreck_ed
arcked136211943ar_ck_ed
becked155417763_beck_ed
bricked164312063brick_ed
brickle15279933brickle_
brickles162810283brickles
buckled164411883_buckled
cackled164613303_cackled
checked193710023check_ed
chuckled2045163chuckled
cockled163710823_cockled
cracked163514743crack_ed
crackle153611253crackle_
crackles164111273crackles
crankled15408153crankled
creaked143413233creak_ed
creeled104012013cre_eled
creneled11326893creneled
cricked164814283crick_ed
crinkled15357153crinkled
crocked164014433crock_ed
decked145217623_deck_ed
deckle1312012453_deckle_
deckles143312803_deckles
erected103213993erec_ted
feckless17225783f_eckless
feckly18335963f_eckl_y
felled103720303f_e_lled
ferreled1234843ferreled
ferruled1263923ferruled
feruled11318423f_eruled
fettled11378933f_ettled
fickle153912973f_ickle_
fickler16348423f_ickler
flacked173711583flack_ed
fleckless1842893fleckless
flicked174610673flick_ed
flocked174510253flock_ed
fracted1339373frac_ted
franked153610053frank_ed
frazzled20303993frazzled
freakier15246483freakier
freckliest1943383freckliest
freckling1934703freckling
freed95223543fre___ed
frenched17299433frenched
frenzied2144043frenzied
frescoed1436053frescoed
freshed143312593fre_shed
fretted113411853fre_tted
fribbled16305743fribbled
frilled113911603fr_illed
frisked15478823frisk_ed
frivoled1534043frivoled
frizzled20325703frizzled
frockless1843453frockless
fucked164114483f_uck_ed
fueled104913603fue__led
fuelled11369193fue_lled
gecked146911933_geck_ed
grackle14338893grackle_
grackles15309183grackles
grecized2134433grecized
hackled173312493_hackled
heckle153112093_heckle_
heckler16278573_heckler
heckles163711383_heckles
kecked125113173_keck_ed
keckle11359423_keckle_
keckles12318763_keckles
knuckled1463563knuckled
mackled164111923_mackled
necked134715063_neck_ed
nickled144010443_nickled
pecked155019103_peck_ed
pickled164011883_pickled
preceded1438293preceded
precised133213413precised
precited133013813precited
precoded1438863precoded
precooled1446363precooled
precured1339993precured
prefiled143310573prefiled
pricked164613833prick_ed
prickle153611013prickle_
prickles162511093prickles
racked134526083_rack_ed
rackle123917293_rackle_
rankled123910653_rankled
recalled11310803_recalled
recaned102817203_recaned
receded112713043_receded
recited104319103_recited
reckless14257973_reckless
reckoned1546953_reckoned
reclad9311873_rec_lad
recoaled113111783_recoaled
recoded113115033_recoded
recoiled113613213_recoiled
recused104714423_recused
recycled1634813_recycled
reddled102912323_reddled
reeked113717643_reek_ed
reeled74725533_re_eled
refiled114318653_refiled
regaled93615963_regaled
reoiled84316853_reoiled
repled93319783_re_pled
rescaled113311303_rescaled
resiled84621983_resiled
resoled84119283_resoled
retackled1644073_retackled
retiled84420513_retiled
reveled113917753_reveled
reviled114417923_reviled
ricked136523623_rick_ed
rocked135022323_rock_ed
rucked134718763_ruck_ed
ruckle124414583_ruckle_
ruckles133414603_ruckles
runkled12399013_runkled
shackled18277603shackled
sickled144713433_sickled
spackled17297803spackled
specked16329013speck_ed
speckle15297553speckle_
speckles16268133speckles
stickled15298973stickled
strickled1665833strickled
suckled144212513_suckled
tackled143913193_tackled
tickled144313133_tickled
trachled1438313trachled
tracked143716133track_ed
treadled1067123treadled
trebled1038483tre_bled
treddled1134473treddled
trekked1134343tre_kked
trembled1335253trembled
tricked144016163trick_ed
trickle133613443trickle_
trickles143013763trickles
trocked144312243trock_ed
trucked143910813truck_ed
truckle13358863truckle_
truckler14297453truckler
truckles14319383truckles
wracked174110113wrack_ed
wreaked15369023wreak_ed
wrecker16367603wreck_er
wrestled12296763wrestled
wricked174910193wrick_ed
wrinkled16275353wrinkled

Search took 9 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 Limit1461621707.97018339.0
3Display Results1701700.0762236.8
 (SQL Overall)1786911708.46921099.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.