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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
tawny11471365(None) 
awny105919301_awny
fawny144711711fawny
lawny115912011lawny
tawney12338231tawney
towny116114491towny
any68440492_a_ny
atony87218852atony
away108024222_away
awn68035912_awn_
awns75324432_awns
awry107619682_awry
barny105821732barny
bawdy147513282bawdy
bawty135614102bawty
brawny144710602brawny
canny105817692canny
carny105822922carny
dawn85624202dawn_
dawns95916592dawns
downy125714552downy
fanny114816042fanny
fawn105321952fawn_
fawns115914262fawns
gawky16569992gawky
gawsy12459092gawsy
lawn75925632lawn_
lawns85215422lawns
many95731862ma_ny
mawn94424142mawn_
nanny84813812nanny
pawky173810152pawky
pawn94625302pawn_
pawns108818132pawns
rainy85921082rainy
rawly115115832rawly
sawn75428162sawn_
sawney12387602sawney
tabby125213892tabby
tacky145617442tacky
taffy145110822taffy
tain45548072tain_
tains54936322tains
taint55542282taint
talky126215682talky
tally84526862tally
tammy124013222tammy
tan37167572ta_n_
tang56138672ta_ng
tangy94519932tangy
tank85134022ta_nk
tannoy958352tannoy
tans46154822ta_ns
tansy84514932tansy
tardy94720462tardy
tarn46842722tarn_
tarns56433952tarns
tarry85422512tarry
tarty86328182tarty
tasty84820312tasty
tatty84720182tatty
taunt55532282taunt
taw610155452taw__
tawdry13395252tawdry
tawed95926192tawed
tawer85223442tawer
tawie84819812tawie
tawing104521552tawing
tawneys13324772tawneys
tawnily1335442tawnily
taws75641592taw_s
tawse85616502tawse
teeny85417882teeny
tinny85317652tinny
tiny76134632t_iny
tony75635152t_ony
town76928702town_
towns86018882towns
towy105325472tow_y
tranny94210862tranny
tunny86515032tunny
twang94511852twang
twangy13386982twangy
twanky16445772twanky
twiny116012812twiny
wany106432362wa_ny
yawey14458272yawey
yawn106219092yawn_
yawns114213272yawns
zany167316992za_ny

Search took 9 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.686260482.5
2DLD Change Limit53800907.5167158.1
3Display Results90900.0461956.5
 (SQL Overall)178691908.24821664.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.