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

130 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
ahoy10191918(None) 
hoy97447911_hoy
abhor10411062abhor
ably99725132ably
abo59045962abo_
abos67734412abos
aby810238062a_by
achoo10315082achoo
achy126316092achy
ado49146872ado_
ados57633512ados
aeon45634612aeon
aery77231682aery
agly86821802agly
ago48845522ago_
agog68019002agog
agon56531882agon
agony96415652agony
ah513868792ah__
aha611246642ah_a
ahed89536252ahed
ahem97225362ahem
ahi68040232ah_i
ahis76135382ahis
ahold94714252ahold
ahs68644822ah_s
airy75734152airy
alky115920342alky
alloy85519972alloy
ally76935642ally
aloe45540192aloe
alow75328592alow
amok10217402amok
annoy869712annoy
anoa45634472anoa
anomy105113392anomy
anon46134852anon
any68440492a_ny
apo511142122apo_
apod78123182apod
apos65433822apos
army96624182army
arty77531312arty
ashy107717352ashy
atom67824522atom
atomy107415192atomy
atony87218852atony
atop66124752atop
atopy106813392atopy
avo68936232avo_
avos77227012avos
avow107816462avow
away108024222away
awny105919302awny
awol75620672awol
awry107619682awry
axon115524302axon
ay511773892a__y
azo128233392azo_
azon135725052azon
boy87753562_boy
buoy95921782buoy
cahow135110942cahow
chay124924872chay
choky175711222choky
chon96627792chon
chop116024922chop
chow125820992chow
cloy96623832cloy
coy810557552_coy
dhow116614002dhow
foy96044262_foy
goy77844552_goy
hao67251122hao_
hay97358772_hay
hazy1918119192hazy
hey96741062_hey
ho510258272_ho_
hob87550922_hob
hod76852462_hod
hoe67562722_hoe
hog78049062_hog
holy106333432_holy
homy126623222_homy
hon67759382_hon
hop87554592_hop
hos68364192_hos
hot67776062_hot
how97252432_how
hoya107418372_hoya
hoys107733932_hoys
joy137036362_joy
mahoe10315572mahoe
mho86624622mho_
mhos95517772mhos
oho66534382oho_
oy58950132__oy
phon95925382phon
phony136715442phony
phot95534362phot
ploy96123602ploy
rho65924832rho_
rhos76319062rhos
savoy114713882savoy
shay107133342shay
shod86225062shod
shoe75933442shoe
shog86025142shog
shoo75929892shoo
shop95629842shop
shot76150262shot
show106229192show
showy145714012showy
shoyu1138912shoyu
shy96728192sh_y
soy67851452_soy
they107223752they
tho67433962tho_
thou76722212thou
thy97022912th_y
toy69655192_toy
troy77429682troy
wahoo112413082wahoo
whey135018712whey
who95526772who_
whoa106615202whoa
whom127018182whom
whop125520922whop
why126920012wh_y
yahoo112911542yahoo

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.280638182.1
2DLD Change Limit298721300.90632971.3
3Display Results1301300.0304333.3
 (SQL Overall)1786911301.216146949.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.