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

166 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
jetway1910527(None) 
jetways2094051jetways
beltway1564372beltway
betray111511442betray
getaway1444012getaway
jetlag1434522jetlag
jetsam15116322jetsam
jetty156212582jet_ty
keyway1943822keyway
leeway1255882leeway
seaway12309992seaway
airway1237693airway
alway116113923_alway
anyway1534803anyway
areaway1335913areaway
astray95615543astray
away108024223__away
belay105021523be_lay
beltways1683903beltways
benday123810813benday
beta66234133bet_a_
betas75528763bet_as
betony114211583betony
betrays12127823betrays
betta74916843betta_
bettas84913923bettas
bewray14147733bewray
byway1647533_byway
cogway1566183cogway
cutaway1544433cutaway
decay114718483de_cay
deejay1734523deejay
deewan10267553deewan
defray1337643defray
delay94820633de_lay
deray95024183de_ray
dewan95718043de_wan
dewar95817733de_war
dewax165510853de_wax
dewy115419023de_w_y
embay123410603_embay
essay867623_essay
estray95713333estray
eta35834193_et_a_
etas46432273_et_as
etna46415263_etna_
etnas54713933_etnas
etwee84115333_etwee
fatwa1168063fatwa_
fatwas1249053fatwas
feta76528903fet_a_
fetal85623373fet_al
fetas85624403fet_as
fetial95716193fetial
flyway18134693flyway
footway1635253footway
freeway1635603freeway
gateway1434923gateway
geta56627443get_a_
getas65421483get_as
getaways1543343getaways
headway1745553headway
hetman112510603hetman
heyday1635143heyday
jawan15710383j_awan
jay136242673j___ay
jean116629283je__an
jehad1637683je_had
jelly154218253je_lly
jemmy19498553je_mmy
jenny153811623je_nny
jerky196712423je_rky
jerry155016183je_rry
jersey1636333jersey
jet106754823jet___
jetbead1742983jetbead
jete115927253jet__e
jetes124922843jet_es
jetlags1533863jetlags
jeton124815403jet_on
jetons134512613jetons
jets115834103jet__s
jetsams16124103jetsams
jetsom15126143jetsom
jetted143915083jetted
jetton1338033jetton
jew135129083je_w__
jewed165114833je_wed
jewel156711703je_wel
jews145822083je_w_s
jitney16304623jitney
jota116423623jot_a_
jotas125717443jot_as
jotty155012603jot_ty
jowar155211433j_owar
jowly186410903j_owly
jutty154914643jut_ty
keyways2043373keyways
leeways1354453leeways
lethal939803lethal
logway1335913logway
meta65932413met_a_
metal75427383met_al
midway15327153midway
nettly9459453nettly
netty85816763net_ty
newly114610203ne_wly
newsy11489393ne_wsy
noway111112843_noway
oilway1235743oilway
outlay92711793outlay
outsay92611873outsay
outwar91011513outwar
partway1535923partway
pathway1844853pathway
petal76526893pet_al
petnap1037423petnap
petsai838083petsai
petty105320293pet_ty
redbay1238333redbay
relay84424673re_lay
repay104818453re_pay
replay113412923replay
resay85320543re_say
retag63618413ret_ag
retax124517973ret_ax
reteam83214533reteam
retear63115483retear
retia55326113retia_
retial64724993retial
retiary1038333retiary
retral64419743retral
retry84718083ret_ry
rewan85623663re_wan
rewax155713923re_wax
runway12105973runway
satay84718463sat_ay
seawan94111223seawan
seaways13307513seaways
seta45637313set_a_
setae56026223set_ae
setal56430903set_al
sewan85921293se_wan
sewar85421093se_war
skyway1933343skyway
stay78333723_st_ay
stewy116112063stew_y
stray88525573_stray
subway1447073subway
sway107128233__sway
tetany959843tetany
tetchy1436003tetchy
tetra53417953tetra_
tetrad73612053tetrad
tetras63017613tetras
tray77632593__tray
twa67721643__twa_
twae74719573__twae
twas76824083__twas
twat75831513__twat
veejay1933703veejay
way96757663___way
wetly114511713wet_ly
wetware1335793wetware
zeta135121643zet_a_
zetas145018163zet_as

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.1701051123.5
2DLD Change Limit1127161666.09318499.3
3Display Results1661660.0463608.7
 (SQL Overall)1786911666.30928323.2
 
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.