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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

138 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
anyway153480(None) 
anyways1644421anyways
airway1237692airway
alway116113922a_lway
away108024222a__way
byway1647532_byway
flyway18134692flyway
gangway1544232gangway
keyway1943822keyway
laneway1345272laneway
naysay1234972naysay
noway111112842_noway
skyway1933342skyway
adyta936853adyta_
affray1534973affray
airways1336243airways
ajowan1634893ajowan
allay85620393a_llay
alleyway1752823alleyway
always12409133a_lways
ana39559833an__a_
anabas8314083anabas
anal48037523an__al
anally9513503anally
anas46649863an__as
anear55420323an_ear
anergy10156863anergy
anew76623133anew__
anga56831353an_ga_
angary10311323angary
angas65827983an_gas
angry9310863an_gry
anima74620073anima_
animacy1446103animacy
animal85016253animal
animas84418723animas
anlas55626933an_las
anna45529013an_na_
annal56520763an_nal
annas55824883an_nas
anneal64812293anneal
annoy869713an_noy
annual64710703annual
anoa45634473an_oa_
anoas57226493an_oas
anodal72512123anodal
anomaly1238843anomaly
anomy105113393an_omy
anorak1038923anorak
ansa45927773an_sa_
ansae55720973an_sae
answer936893answer
anta46839583an_ta_
antae56828293an_tae
antas55432033an_tas
antiar6317173antiar
antigay1148223antigay
antiwar1037963antiwar
antra56521923antra_
antral65719413antral
antsy85712793an_tsy
anural65714743anural
anuran64313243anuran
any68440493an___y
anybody1642573anybody
anyhow1544103anyhow
anyon85615223any_on
anyone94612733anyone
anyons94513503anyons
anywise1345203anywise
archway1844893archway
areaway1335913areaway
array86317143a_rray
assay8710283a_ssay
astray95615543astray
asyla839333asyla_
avowal1246323avowal
awa611939673a__wa_
awny105919303a__wny
awry107619683a__wry
ayah108022993a_y_ah
banyan1139483bany_an
byways1734673_byways
caraway1538133caraway
cogway1566183cogway
endways1444443endways
entryway1742023entryway
fairway1644333fairway
faraway1645413faraway
flyaway1943163flyaway
flyways19133853flyways
gangways1643733gangways
gateway1434933gateway
halfway1943763halfway
hallway1636173hallway
haniwa1236743haniwa_
heyday1635143heyday
inlay85214323in_lay
jetway19105273jetway
keyways2043373keyways
laneways1444573laneways
layaway1643933layaway
leeway1255883leeway
logway1335913logway
mayday1535883mayday
midway15327153midway
narwal938943narwal
nawab10810923_nawab
nay66952773_n__ay
naysays1344123naysays
newly114610203_newly
newsy11489393_newsy
noways12127733_noways
oilway1235743oilway
onlay84212943on_lay
parkway1934553parkway
partway1535923partway
pathway1844853pathway
payday1536613payday
psywar1443323psywar
raceway1546133raceway
railway1345313railway
runaway1343683runaway
runway12105973runway
seaway12309993seaway
skyways2043223skyways
snowy115011563snow_y
subway1447073subway
sway107128233__sway
taxiway2043463taxiway
unlay84613703un_lay
unsay83212843un_say
unwary1239823un_wary
walkway2043373walkway
way96757663___way
waylay1535453waylay
windway1745153windway
yay96948713__y_ay

Search took 7 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 Filter1786911127160.703254183.5
2DLD Change Limit1127161385.64019985.1
3Display Results1381380.0463000.0
 (SQL Overall)1786911386.38927968.5
 
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.