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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
to automatically increase the Change Limit after seconds.

93 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
avow10781646(None) 
alow75328591alow
avo68936231avo_
avos77227011avos
avows114910981avows
vow96136311_vow
abo59045962abo_
abos67734412abos
ado49146872ado_
ados57633512ados
adown95611662adown
aeon45634612aeon
aglow94711972aglow
ago48845522ago_
agog68019002agog
agon56531882agon
ahoy101919182ahoy
allow85420662allow
aloe45540192aloe
amok10217402amok
anew76623132anew
anoa45634472anoa
anon46134852anon
apo511142122apo_
apod78123182apod
apos65433822apos
arrow83414882arrow
arvo76023432arvo_
arvos86015662arvos
atom67824522atom
atop66124752atop
ava610139322av_a
ave67748702av_e
aver75931882aver
aves76142602aves
avid88325962avid
avion84218342avion
avoid95516682avoid
avowal1246322avowal
avowed1335962avowed
avower1236822avower
aw512563402a__w
awol75620672awol
axon115524302axon
azo128233392azo_
azon135725052azon
blow95827192blow
bow87051902_bow
brow97228442brow
cahow135110942cahow
chow125820992chow
cow89856712_cow
crow96428132crow
dhow116614002dhow
dow76749972_dow
enow77819872enow
favor114712452favor
flow105924922flow
frow106425052frow
gavot9321122gavot
glow85222522glow
grow86127302grow
havoc1337182havoc
how97252432_how
jow137639302_jow
know116115842know
low66051872_low
meow95117882meow
mow86650352_mow
now65950192_now
ow58950172__ow
plow95923232plow
pow87147282_pow
prow97030382prow
reavow1235722reavow
row67453672_row
savor85417942savor
savoy114713882savoy
scow96021422scow
show106229192show
slow77729492slow
snow76324792snow
sow66554762_sow
stow77325742stow
tow610557362_tow
trow78031422trow
vaw95937462_vaw
voe67739052_voe
vows106626942_vows
vox136628152_vox
vrow105817472vrow
wow96643472_wow
yow96945292_yow

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.283631417.0
2DLD Change Limit29872930.89033564.0
3Display Results93930.0165812.5
 (SQL Overall)178691931.189150286.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.