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

144 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
awned9661595(None) 
acned87520661acned
awed88436031aw_ed
dawned113912091dawned
fawned134910421fawned
owned95113231owned
pawned124513281pawned
waned95831781waned
yawned13509841yawned
aahed917816442aahed
abed79734132a_bed
abled86926832abled
aced79540882a_ced
ached119227832ached
acne66625872acne_
acnes75922622acnes
acred87126352acred
acted88521732acted
added84918432added
adzed166012542adzed
aged67334252a_ged
ahed89536252a_hed
aided75828932aided
ailed66240282ailed
aimed85626052aimed
aired66032922aired
alined75221402alined
amend85717752amend
amped104820512amped
and47244162a_n_d
ane37866942a_ne_
anes45255932a_nes
anew76623132a_new
annex12310882annex
anted66328242anted
aped78538152a_ped
apnea73413412apnea
arced88224162arced
armed86324432armed
ashed97829772ashed
asked106919312asked
atoned75417542atoned
awaked14579202awaked
award97118042award
awe67746622aw_e_
awee76336642aw_ee
awes76037552aw_es
awn68035912awn__
awns75324432awn_s
awny105919302awn_y
axed128829612a_xed
axled135315812axled
baned85436352baned
banned94721342banned
barned95623582barned
bawled124415692bawled
boned85133242boned
caned85838092caned
canned95022062canned
cawed116627062caw_ed
coned86040052coned
damned104212912damned
darned85018482darned
dawed106222812daw_ed
dawted11489682dawted
dined76431992dined
downed115314782downed
dwined114610212dwined
earned74818332earned
fanned104117472fanned
fawner125910462fawner
fined94930502fined
gained84617462gained
gawked15468762gawked
gawped13509072gawped
gowned114410132gowned
hawed126025422haw_ed
hawked174712672hawked
honed95332262honed
inned64118422inned
jawed165517372jaw_ed
lawed96028322law_ed
lined64934642lined
maned86634092maned
manned94418642manned
mawed115824742maw_ed
mined85333352mined
owed86833872ow_ed
owner84613312owner
pained95622852pained
paned85437182paned
panned94123432panned
pawed115725612paw_ed
pawnee113115402pawnee
pawner114212922pawner
pined85935322pined
prawned1346742prawned
rained75024602rained
sained75424242sained
saned65636272saned
sawed95628402saw_ed
sawney12387602sawney
sned56026052_sned
spawned13316802spawned
tanned75219952tanned
tawed95926192taw_ed
tawney12338232tawney
tawsed10499742tawsed
tined65434532tined
toned65435342toned
tuned64622312tuned
tweed94915092tweed
twined104413122twined
tyned95915012tyned
unwed94114872unwed
vaned94622422vaned
vanned104614482vanned
vined95626152vined
waded106024752waded
waged104822782waged
waked135626752waked
waled94330992waled
wand85833872wan_d
wane76344712wane_
wanes85040882wanes
waney115120322waney
wanked144517152wanked
wanned104318012wanned
wanted104319722wanted
wared96339872wared
warned104018912warned
waved125223582waved
wawled133811702wawled
waxed166018482waxed
wed75843622_w_ed
weed85637512_weed
wend85330452_wend
wined94434182wined
yarned105514022yarned
yawed126022452yaw_ed
yawled13459982yawled
yawner12428472yawner
yawped15528102yawped
zoned154020262zoned

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.0931921408.6
2DLD Change Limit538001441.40638264.6
3Display Results1441440.0304800.0
 (SQL Overall)1786911441.529116867.9
 
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.