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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

199 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
cline7642853(None) 
aline57243151aline
chine105231721chine
cine66242941c_ine
clime95720891clime
clines84926041clines
cling86424671cling
clink115320041clink
clone75728161clone
line46965571_line
alane56135612alane
alien56425582alien
alike95523962alike
alined75221402alined
aliner65621982aliner
alines65735222alines
alive85722512alive
alkine104916802alkine
alone55732962alone
alpine84417372alpine
alvine94614582alvine
amine75835382amine
azine146721412azine
bine66650862_bine
blin67228172blin_
blind86319322blind
blini75519272blini
blink115720142blink
blite76225352blite
brine75132272brine
byline11311642byline
cain65643912cain_
cains75334302cains
calcine11315272calcine
cane66653122c_ane
canine83826702canine
carline93923612carline
cauline92215602cauline
chaine115119222chaine
chide115321012chide
chile105626892chile
chime125322592chime
chin96934742chin_
china105022482china
chined125620062chined
chines115029172chines
chink145321592chink
chino105823312chino
chins105631462chins
chive135117622chive
choline122915382choline
cilice103213352cilice
cines75239682c_ines
cire65836372c_ire
cite65640342c_ite
clade85821012clade
clan65633922clan_
clang86019312clang
clank114719522clank
clans75031012clans
clave105420152clave
clepe94617382clepe
cliche133712452cliche
click135217952click
client8316342client
cliff135917132cliff
clift106422192clift
climb115413592climb
climes104720002climes
clinal8311552clinal
clinch133910352clinch
clinged113310092clinged
clinger103812152clinger
clings95716212clings
clingy12659062clingy
clinic104312792clinic
clinked144011642clinked
clinker133811662clinker
clinks125815062clinks
clip86924002cli_p
clips96018302clips
clipt96324272clipt
clique17289192clique
clon66232482clon_
cloned94518802cloned
cloner84418092cloner
clones84526562clones
clonk114417442clonk
clons75228132clons
close76425222close
clove105619442clove
cloze165517542cloze
clue65324532cl_ue
cluing93913502cluing
clung86013602clung
clunk114215082clunk
coigne94612192coigne
coin66645352coin_
coined94523602coined
coiner84323782coiner
coins75834552coins
colin76231692colin_
colins85229042colins
colone85425002colone
cone67256962c_one
conine84528552conine
cosine83823512cosine
crane75331602crane
crime94822692crime
cringe93515482cringe
cripe95521142cripe
crone75231332crone
cuing85420192cuing
cutline92914542cutline
decline103716612decline
dine55555332_dine
dwine95616142dwine
elide64922642elide
elint55436472elint
elite56230182elite
exine125518492exine
feline94820142feline
fine75147952_fine
fling97023512fling
flint87333502flint
flite85424962flite
glide74521592glide
glime85620192glime
glint66830182glint
gwine95513662gwine
imine75821062imine
incline9314642incline
kine85643432_kine
koine9516482koine
lane45153332_lane
liane54720662_liane
lice66045062_lice
lie38264522_li_e
lien45339802_lien
life75433732_life
like86040842_like
lime66244932_lime
lin37967372_lin_
lined64934642_lined
linen55728722_linen
liner55938922_liner
lines57054572_lines
liney87029632_liney
ling57447962_ling
link86943442_link
linn46034592_linn
lino46343372_lino
lins47059052_lins
lint416266232_lint
liny78141322_liny
lipe66839732_lipe
lire47845292_lire
lite47054542_lite
live76540992_live
lone45849132_lone
lune47140492_lune
maline84529082maline
mine67256172_mine
moline84422032moline
nine45842172_nine
oleine6313792oleine
olive84817152olive
online6315842online
opine77422462opine
ovine86316642ovine
pine67755712_pine
plane74929142plane
plie65127392pli_e
plink115219122plink
recline94020492recline
reline65434352reline
saline65132702saline
seine55732872seine
shine85533092shine
sine46560622_sine
slice74925822slice
slide64725412slide
slime74925752slime
sling66028802sling
slink95422912slink
slipe75626132slipe
spine76534422spine
spline86020532spline
swine85625302swine
thine85026862thine
tine45855132_tine
trine54734602trine
twine85822362twine
urine55026602urine
valine94623092valine
vine75643682_vine
whine116022812whine
wine74953422_wine
zine137036152_zine

Search took 2 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.406440125.6
2DLD Change Limit538001991.51635488.1
3Display Results1991990.0464326.1
 (SQL Overall)1786911991.96890798.3
 
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.