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

141 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
johnny193219(None) 
bonny105816622bo_nny
jenny153811622j_enny
john145512902joh_n_
johnnie1772282johnnie
johns15398712joh_ns
jouncy18336202jouncy
sonny85016102so_nny
benny105217363_benny
blenny1156203blenny
bohunk1533743bohunk
boney105227313bo_ney
bonne75124713bo_nne
bony96732083bo__ny
botany1139263botany
bouncy13409073bouncy
bounty113411073bounty
branny115111833branny
bunny104715803_bunny
canny105817693_canny
cohune1189423cohune
colony115417273colony
coney105932883co_ney
conky145818743co_nky
conn66229133co_nn_
conns75024233co_nns
cony96537833co__ny
corny106023273co_rny
county114313323county
cranny114210273cranny
djinny1732873djinny
donna66215033do_nna
donne65520463do_nne
donsy96414683do_nsy
downy125714553do_wny
fanny114816043_fanny
fenny115115133_fenny
finny114716753_finny
fohn106116553foh_n_
fohns117310783foh_ns
funny114614833_funny
ginny95314573_ginny
goanna736653goanna
gobony1236913gobony
gooney106612313gooney
goony95519783go_ony
gowany13457493gowany
granny104311163granny
gunny94413663_gunny
hinny115616673_hinny
hominy144511483hominy
honey115629913ho_ney
honky156218523ho_nky
horny115619623ho_rny
janty156816963j_anty
jaunty16388513jaunty
jiminy1836273jiminy
jinn115420243j_inn_
jinni125310633j_inni
jinns126013843j_inns
jitney16304623jitney
joannes1436243joannes
jockey22408033jockey
jocund1633623jocund
joey145719333jo__ey
johannes1842943johannes
johnnies1872993johnnies
johnson1742333johnson
johnsons1842383johnsons
join116724833jo_in_
joined144613073joined
joiner134114133joiner
joinery17366593joinery
joining153011483joining
joins125818413jo_ins
joint125227723jo_int
jointly1735483jointly
joints133811453joints
jokey195014693jo_key
jokily20306533jokily
joking184113023joking
joky186215313jo__ky
jolly154517513jo_lly
jolty155713033jo_lty
jomon14610083jomon_
jones125028183jo_nes
joshing18519413joshing
jotty155012603jo_tty
jounce153310733jounce
journey1734873journey
journo13135293journo
jowing174216043jowing
jowly186410903jo_wly
joy137036363jo___y
joying173810803joying
junky194513233j_unky
koruny1334443koruny
looney94712413looney
loony86918963lo_ony
loungy10476833loungy
minny104518663_minny
money104826843mo_ney
mony96830013mo__ny
moony104818273mo_ony
nanny84813813_nanny
ninny84514933_ninny
ohing96018813_ohing
only75319723_o_nly
oogeny10117923oogeny
oohing104412933oohing
penny105119453_penny
phoney143612983phoney
phony136715443_phony
pinny105222063_pinny
pointy114913283pointy
pony96434053po__ny
porny106020193po_rny
punny104217713_punny
rosiny94414533rosiny
runny84613483_runny
shanny124110093shanny
shinny124810783shinny
shiny115122143_shiny
skinny13456613skinny
sonly85718053so_nly
sonsy86416373so_nsy
spinny114510183spinny
sunny84917743_sunny
swanny12336823swanny
thorny12509843thorny
tinny85317653_tinny
toney86027413to_ney
tonne54921433to_nne
tony75635153to__ny
towny116114493to_wny
tranny94210863tranny
tunny86515033_tunny
wenny114412463_wenny
whinny15587493whinny
whiny144915573_whiny
wonky154011773wo_nky

Search took 7 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 Filter1786911127160.390458182.1
2DLD Change Limit1127161415.57620214.5
3Display Results1411410.0334272.7
 (SQL Overall)1786911415.99929786.8
 
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.