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

117 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
only7531972(None) 
inly75622211inly
oily77932251oily
onlay84212941onlay
sonly85718051sonly
ably99725132ably
agly86821802agly
ally76935642ally
any68440492an_y
boney105227312boney
bonny105816622bonny
bony96732082bon_y
coaly105521592coaly
colly104926772colly
coly96940532coly
coney105932882coney
conky145818742conky
cony96537832con_y
cooly105525422cooly
coyly135614892coyly
doily95321032doily
dolly96125202dolly
donsy96414682donsy
dooly94821802dooly
doyly124514012doyly
duly85323032duly
eely77725212eely
envy10411252envy
fly97124952_fly
folly115022602folly
fondly13299042fondly
godly104913292godly
golly95121102golly
holly114824432holly
holy106333432holy
honey115629912honey
honky156218522honky
hooly115022222hooly
hotly115815482hotly
idly85617322idly
illy76925332illy
inby95315662inby
inky115321582inky
inlay85214322inlay
jolly154517512jolly
jowly186410902jowly
lily76730182lily
lolly85120662lolly
lonely92912472lonely
longly10279602longly
lowly114113332lowly
manly105022952manly
molly105222492molly
moly96031912moly
money104826842money
mony96830012mon_y
nay66952772_nay
nobly105314402nobly
noily86120992noily
nolo46229312nolo
nonyl849772nonyl
nosy76322892nosy
oaky116419952oaky
obey96521302obey
oddly1037162oddly
odyl84111462odyl
ofay106416102ofay
ogle56325052ogle
oil37452052oil_
oils46337972oils
okay115917662okay
old47033462o_ld
oldy85316842oldy
ole37155212o_le
olla44821172olla
on28057182on__
once65423082once
one37050912on_e
onery8414122onery
ones46146532ones
onlays9398712onlays
ono36838032on_o
onos46229002onos
ons36148512on_s
onto46127662onto
onus45826812onus
onyx1478362onyx
oozy167018132oozy
openly1137122openly
orby97519602orby
orgy85218002orgy
orle45630462orle
owl66228972owl_
owls76022932owls
oxy136320982o_xy
oy58950132o__y
paly95835532paly
pily96132732pily
ply86323552_ply
poly96235152poly
pony96434052pon_y
rely75428952rely
roily86121112roily
ruly76323142ruly
sly66228562_sly
sonny85016102sonny
sonsy86416372sonsy
toney86027412toney
tony75635152ton_y
ugly86012382ugly
undy85015162undy
unlay84613702unlay
waly105830902waly
wanly115118022wanly
wily106428812wily
wonky154011772wonky
wooly114417672wooly

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 Filter178691298720.360496363.9
2DLD Change Limit298721170.98630296.1
3Display Results1171170.0303900.0
 (SQL Overall)1786911171.376129862.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.