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

150 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
freckling193470(None) 
crackling18157002crackling
flecking18408232fleck_ing
freaking163611452freak_ing
frecklier1842992frecklier
frocking18309572frock_ing
heckling18257162_heckling
keckling14245522_keckling
prickling1836532prickling
recking144319922_reck_ing
rockling15259382_rockling
ruckling15258572_ruckling
speckling18235582speckling
trickling1647722trickling
truckling1645072truckling
wrecking18328152wreck_ing
arcking145811963ar_ck_ing
arecoline1147103arecoline
becking164416073_beck_ing
breaking153914253break_ing
bricking173911403brick_ing
buckling17259113_buckling
cackling172610943_cackling
checking20379203check_ing
chuckling2144193chuckling
cockling172310393_cockling
cracking174013903crack_ing
cracklings19143523cracklings
crankling16147293crankling
creaking153414123creak_ing
creeling113513363cre_eling
creneling1247733creneling
cricking173412653crick_ing
crinkling16145863crinkling
crocking174313443crock_ing
decking153915593_deck_ing
duckling16247703_duckling
erecting112415063erec_ting
feeling113617073f_e_eling
felling113321133f_e_lling
ferreling13136273ferreling
ferruling13134423ferruling
feruling1258873f_eruling
fettling1266773f_ettling
flacking184311793flack_ing
fledgling1552473fledgling
flicking184110043flick_ing
flocking183410873flock_ing
franking164310863frank_ing
franklin15104603franklin_
franklins1694763franklins
frazzling2143153frazzling
freckle16106643freckl__e
freckled18104443freckl_ed
freckles17126383freckl_es
freckliest1943383freckliest
freckly19124593freckl__y
freeing113713913fre__eing
freezing21308323fre_ezing
frenching18267753frenching
frenzying2542413frenzying
frescoing1544683frescoing
freshing152611023fre_shing
fretting122711523fre_tting
fribbling1733673fribbling
frilling123011493fr_illing
frisking16268363frisk_ing
frivoling1644493frivoling
frizzling2153113frizzling
fucking173212283f_uck_ing
fueling113615133fue__ling
fuelling123410153fue_lling
gecking154111363_geck_ing
grecizing2235723grecizing
greenling1136753greenling
hackling183310163_hackling
kecking134111883_keck_ing
knuckling1542753knuckling
mackling172710063_mackling
necking143913893_neck_ing
neckline1496363_neckline
nickling15278703_nickling
pecking164017783_peck_ing
pickling17239203_pickling
preceding15129363preceding
precising14413273precising
precoding15109733precoding
precooling1545963precooling
precuring1439423precuring
prefiling1549533prefiling
pricking173212603prick_ing
racking144323663_rack_ing
rankling132610113_rankling
recalling122211903_recalling
recaning111416693_recaning
receding122713763_receding
reciting113118073_reciting
reckoning1637643_reckoning
recline94020493_rec_line
recoaling121312453_recoaling
recoding122213853_recoding
recoiling121412413_recoiling
recusing112512883_recusing
recycling1734903_recycling
reddling112911813_reddling
reedling102414273_reedling
reeking123318643_reek_ing
reeling83126863_re_eling
refiling123116533_refiling
regaling10315363_regaling
reoiling93217213_reoiling
rescaling122212013_rescaling
resiling93520173_resiling
resoling92916303_resoling
retackling1744433_retackling
retiling93319483_retiling
reveling123117083_reveling
reviling122917213_reviling
ricking143920233_rick_ing
rocking143619633_rock_ing
rocklings16224843_rocklings
rucking143216673_ruck_ing
runkling13217613_runkling
shackling19286173shackling
sickling152910333_sickling
spackling18266503spackling
specking17359733speck_ing
stickling1647003stickling
strickling1744953strickling
suckling152410023_suckling
tackling153211123_tackling
tickling15309433_tickling
trachling1537823trachling
tracking153715463track_ing
treadling1137503treadling
trebling1139873tre_bling
treddling1234423treddling
trekking1235543tre_kking
trembling1435193trembling
tricking152714513trick_ing
trocking153612423trock_ing
trucking153310163truck_ing
truckline1544913truckline
weakling16106763_weakling
wracking18349963wrack_ing
wreaking163010213wreak_ing
wreckings19233683wreck_ings
wrestling1336063wrestling
wricking18349493wrick_ing
wrinkling17144953wrinkling

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411506.89321564.1
3Display Results1501500.0632381.0
 (SQL Overall)1786911507.39224173.6
 
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.