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

220 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
airway123769(None) 
airways1336241airways
fairway1644331fairway
airbag956962airbag
airily93014822airily
airman82414222airman
airplay1245482airplay
airward1148132airward
airwave1344432airwave
airy75734152air__y
alway116113922a_lway
anyway1534802anyway
array86317142a_rray
away108024222a__way
fairways1743872fairways
midway15327152midway
oilway1235742oilway
railway1345312railway
stairway1462922stairway
wireway1646042wireway
abroad9310943abroad
aerial64625713aerial
aerify122810113aerify
aerily93017013aerily
aery77231683aer__y
affray1534973affray
agria65517143agria_
agrias74315393agrias
aidman92410623aidman
air38058393air___
airbags1036293airbags
airboat9512133airboat
airbus848343airbus
airdate8311323airdate
aired66032923air_ed
airer54927893air_er
airers64922313airers
airest63825263airest
airfare1047243airfare
airhead1136993airhead
airier64619363airier
airing74927503airing
airmail946213airmail
airmen82612353airmen
airn46433833air__n
airns55521033air_ns
airpark1344923airpark
airplays1344533airplays
airs46447423air__s
airt45757783air__t
airted74214503airted
airth85621023air_th
airths95414253airths
airts55626343air_ts
airwaves1444723airwaves
airwise1036713airwise
airwoman1344673airwoman
aisleway1442523aisleway
ajowan1634893ajowan
allay85620393a_llay
already1144263already
always12409133a_lways
anyways1644423anyways
aorta55922573aorta_
aortae65115473aortae
aortal65217513aortal
aortas65417783aortas
arak86929573a_r_ak
archway1844893archway
area45843393a_rea_
areae55229743a_reae
areal55928733a_real
areas55935773a_reas
areaway1335913areaway
argal65023393a_rgal
arhat8327093a_rhat
aria46245423a_ria_
ariary94114203ariary
arias55438023a_rias
aridly105513703aridly
army96624183a_r_my
arras55626133a_rras
arrays95311683a_rrays
arrear6310253arrear
arrowy12288273arrowy
artal55525473a_rtal
artsy86012963a_rtsy
arty77531313a_r_ty
arval86017013a_rval
assay8710283a_ssay
astray95615543astray
atria56022343atria_
atrial65418943atrial
aura45836253aur_a_
aurae54128113aur_ae
aural54428963aur_al
aurar54420253aur_ar
auras55932563aur_as
avowal1246323avowal
awa611939673a__wa_
awny105919303a__wny
awry107619683a__wry
bairnly1234503bairnly
bewray14147733bewray
bikeway1944313bikeway
bray95232903_br_ay
byway1647533_byway
cairny11557823cair_ny
caraway1538133caraway
circa9311403circa_
cogway1566183cogway
dairy97016303dair__y
deray95024183der_ay
diram84419473dir_am
direly10311563direly
dirham12378273dirham
dirty95617803dir_ty
dismay12229473dismay
diwan95712553di_wan
doorway1444243doorway
dray85428093_dr_ay
earwax1664733earwax
fairly125610013fair_ly
fairy115318283fair__y
faraway1645413faraway
firman112211343firman
firmly1436663firmly
firry115713533fir_ry
fishway1943813fishway
flyway18134693flyway
foray115023973for_ay
forwhy1834423forwhy
fray105428903_fr_ay
gainsay1144043gainsay
gangway1544233gangway
gateway1434933gateway
girly94415293gir_ly
gray85329893_gr_ay
haircap14134753haircap
hairy115316833hair__y
halfway1943763halfway
hallway1636173hallway
highway2044263highway
hurray12459913hurray
inlay85214323_inlay
irony85015903_irony
jetway19105273jetway
keyway1943823keyway
lairdly1134913lairdly
laneway1345273laneway
layaway1643933layaway
leeway1255883leeway
lifeway1644273lifeway
lira46928683lir_a_
liras56021983lir_as
logway1335913logway
margay12310593margay
midday13327503midday
midways16386183midways
mirky146315523mir_ky
miry96326753mir__y
mirza16410443mirza_
mirzas1738183mirzas
mislay113510683mislay
missay114112143missay
moray105423793mor_ay
naira5314743nair_a_
nairas6312783nair_as
narwal938943narwal
noway111112843_noway
oilways1334873oilways
parkway1934553parkway
parlay113713993parlay
partway1535923partway
pathway1844853pathway
piracy1339473piracy
piraya1167713pir_aya
pray96331533_pr_ay
raceway1546133raceway
railways1444603railways
ray66361993__r_ay
runway12105973runway
seaway12309993seaway
shipway1844213shipway
sideway1445673sideway
sirdar7269103sirdar
sirra54416323sirra_
sirrah9379753sirrah
sirras63814863sirras
sirupy11377053sirupy
skidway1843083skidway
skyway1933343skyway
slipway1543873slipway
spray106720063spr_ay
stairways1582403stairways
strawy1210312823strawy
stray88525573str_ay
subway1447073subway
sway107128233__sway
taxiway2043463taxiway
thruway1643163thruway
tideway1445153tideway
trainway1444223trainway
tray77632593_tr_ay
viewy14518103view_y
viral86419593vir_al
virelay1335943virelay
virga9310253virga_
virgas1048883virgas
walkway2043373walkway
waterway1745563waterway
way96757663___way
wigwag1443723wigwag
wigwam1544723wigwam
windway1745153windway
wireways1745833wireways
wirily123310783wirily
wirra83210823wirra_
wiry106422833wir__y
ziram163912893zir_am

Search took 6 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.376475242.0
2DLD Change Limit1127162205.00022543.2
3Display Results2202200.0603666.7
 (SQL Overall)1786912205.43632871.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.