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 “clung” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

81 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
clung8601360(None) 
clang86019311clang
cling86424671cling
cluing93913501cluing
clunk114215081clunk
flung95114581flung
lung55732491_lung
slung65117831slung
alang66023512alang
along65419492along
bluing94914482bluing
blunge94311482blunge
blunt75525022blunt
brung84613912brung
bung75730632_bung
chang115418562chang
chug105914112chu_g
chunk144812382chunk
clag75924572cl_ag
clan65633922clan_
clangs95113612clangs
clank114719522clank
clans75031012clans
cline76428532cline
clings95716212clings
clingy12659062clingy
clink115320042clink
clog76123242cl_og
clon66232482clon_
clone75728162clone
clonk114417442clonk
clons75228132clons
club85819472clu_b
clubs95415102clubs
cluck134914892cluck
clue65324532clu_e
clued84917682clued
clueing104110092clueing
clues74623032clues
clump115517452clump
clunks124811012clunks
clunky15447892clunky
count74932052count
cuing85420192cuing
cunt66243672c_unt
dung66328432_dung
fling97023512fling
flong95815682flong
flunk125014382flunk
glug66118012glu_g
gluing83812052gluing
hung86126352_hung
klong105310402klong
lang56637392_lang
ling57447972_ling
long56933342_long
lug46138062_lu_g
luna46229852_luna
lune47140492_lune
lunge65323802_lunge
lungi65516052_lungi
lungs65223882_lungs
lunk86030722_lunk
lunt46148842_lunt
luny77324132_luny
plug74915992plu_g
plunge93811062plunge
plunk114514402plunk
pung75429632_pung
rung56429982_rung
slang66324022slang
sling66028802sling
slug55124642slu_g
sluing74315882sluing
slunk95016302slunk
stung65417152stung
sung55832172_sung
swung95610562swung
tung55328172_tung
wrung9549802wrung
young977742young

Search took 3 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 Filter178691538000.310576422.6
2DLD Change Limit53800811.70331591.3
3Display Results81810.0332454.5
 (SQL Overall)178691812.04687336.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.