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

121 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
crony10591867(None) 
cony96537831c_ony
corny106023271corny
crone75231331crone
irony85015901irony
acronym1445672acronym
agony96415652agony
atony87218852atony
barony115915302barony
bony96732082_bony
briny104719662briny
briony1149042briony
bronc91714342bronc
bronzy20306712bronzy
brosy106115382brosy
browny144510042browny
bryony1435832bryony
canny105817692canny
carny105822922carny
choky175711222choky
chon96627792chon_
chromy16309902chromy
cion613330912cion_
cions75222852cions
clon66232482clon_
clone75728162clone
clonk114417442clonk
clons75228132clons
cloy96623832clo_y
coky137526822c_oky
colony115417272colony
coly96940532c_oly
con510268022c_on_
cone67256962c_one
coney105932882c_oney
coni65534802c_oni
conk106531442c_onk
conky145818742c_onky
conn66229132c_onn
cons66057692c_ons
cooey105828222cooey
cooky145321362cooky
cooly105525422cooly
coon67248942coon_
coons76737282coons
copy116229802c_opy
corby125018532corby
corky145221152corky
corn69945812corn_
corns76034762corns
cornu75921322cornu
corody12149702corody
corona83817402corona
cory96941512c_ory
cosy97232702c_osy
cowy126427362c_owy
coy810557552c_o_y
cozy185823802c_ozy
crane75331602crane
crank114819612crank
cranky153910632cranky
cranny114210272cranny
crazy195511222crazy
crepy124812702crepy
croak115216632croak
croaky15528482croaky
croc85723732cro_c
croci95818132croci
crock135921992crock
crocs95722432crocs
croft105622682croft
crones84729242crones
crook115217572crook
croon75522782croon
croons85418422croons
crop87628632cro_p
crops96125232crops
crore74922862crore
cross75124502cross
croup95616782croup
croupy13458732croupy
crow96428132cro_w
crowd115815622crowd
crowdy15467172crowdy
crown105620082crown
crowns115615112crowns
crows105727312crows
croze164719452croze
cry89726242cr__y
drone65324982drone
ebony104511512ebony
frond95316342frond
frons86124042frons
front85029222front
goony95519782goony
grody103412062grody
horny115619622horny
iron46728462iron_
irone55126362irone
irons55324132irons
krona93611792krona
krone94018732krone
loony86918962loony
mony96830002_mony
moony104818272moony
peony105717562peony
phony136715442phony
pony96434052_pony
porny106020192porny
prone75332622prone
prong85218112prong
prosy106319252prosy
proxy175011012proxy
ropy96323412_ropy
rosy76024872_rosy
stony85818642stony
tony75635152_tony
trona54118952trona
trone55131862trone
troy77429682tro_y
wrong94712322wrong

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.1101624463.6
2DLD Change Limit538001211.73630990.8
3Display Results1211210.0304033.3
 (SQL Overall)1786911211.87695251.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.