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

209 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
logway133591(None) 
cogway1566181cogway
logways1434511logways
cogways1634632cogways
leeway1255882leeway
logan68123282log_an
loggy105714192log_gy
logia68116602logia_
logily1039832logily
logjam1635362logjam
logy87025782log__y
longways1543872longways
lowly114113332lo_wly
noway111112842no_way
airway1237693airway
alway116113923_alway
anyway1534803anyway
away108024223__away
blowby16467513blo_wby
blowsy14579453blo_wsy
blowy134315323blo_w_y
blowzy23516673blo_wzy
bogan87519003bog_an
bogey115220233bog_ey
boggy126116073bog_gy
bogy106426193bog__y
byway1647533_byway
cloggy1344873clog_gy
cognac1157273cognac
colorway1644493colorway
copay126516313co_pay
cowry135512483co_wry
cowy126427363co_w_y
dogear838193dogear
dogey105719513dog_ey
doggy115214873dog_gy
dogma96112463dogma_
dogmas105011243dogmas
dognap1035343dognap
dogy96126493dog__y
doorway1444243doorway
dowdy136112543do_wdy
downy125714553do_wny
dowry126312483do_wry
floodway1842683floodway
flyaway1943163flyaway
flyway18134693flyway
fogey125617873fog_ey
foggy136714543fog_gy
fogy115923183fog__y
folkway2043353folkway
footway1635253footway
foray115023973fo_ray
forwhy1834423forwhy
gangway1544233gangway
gay76856493__g_ay
goggly12337053goggly
gowan95415743go_wan
gowany13457493go_wany
gray85329893__gray
highway2044253highway
hogan97817703hog_an
hogwash1742703hogwash
hooray123011373hooray
howdy155711413ho_wdy
jetway19105273jetway
jowar155211433jo_war
jowly186410903jo_wly
keyway1943823keyway
lagan66520343lag_an
laneway1345273laneway
laogai735983laog_ai
lawny115912013l_awny
lay68865353l___ay
layaway1643933layaway
leeways1354453leeways
legacy1256653legacy
legal65715943leg_al
leggy105210243leg_gy
legman949653legman
lifeway1644273lifeway
ligan67920283lig_an
lignan75510323lignan
load56730603lo__ad
loaf76734903lo__af
loam65630483lo__am
loamy105913343lo_amy
loan47436453lo__an
lobar7313013lo_bar
lobby125113913lo_bby
loca65527683lo_ca_
local74820273lo_cal
lochan1139093lochan
lofty115813303lo_fty
log46252683log___
logans76319063logans
loge56837193log__e
loges66534203log_es
loggats9286453loggats
logged96622943logged
logger86420003logger
loggia8457053loggia
loggias9356783loggias
loggie84011993loggie
logic88217833log_ic
logical1038513logical
logics95711123logics
logier75015733logier
login66025003log_in
logins77820643logins
logion76013723logion
logjams1743583logjams
logo57931763log__o
logoi69715943log_oi
logon615922313log_on
logons79818173logons
logos67225333log_os
logs57343113log__s
logwood1255573logwood
lolly85120663lo_lly
lonely92912463lonely
longan75612363longan
longly10279603longly
looby108115623lo_oby
looey84822913lo_oey
loofa85912813loofa_
loofah12375813loofah
loofas9429833loofas
looney94712403looney
loony86918963lo_ony
loopy105316643lo_opy
loppy125911663lo_ppy
loquat1558283loquat
loral55927823lo_ral
loran55925093lo_ran
lordly1038753lordly
loreal63814313loreal
lorry86315663lo_rry
lory75931713lo__ry
lossy85214643lo_ssy
lota47233503lo_ta_
lotah85315853lo_tah
lotas55926303lo_tas
loudly1037783loudly
louma76213633louma_
loumas84812333loumas
loungy10476833loungy
loury85716753lo_ury
lousy84617083lo_usy
lovat8321043lo_vat
lovely12339713lovely
low66051873lo_w__
lowboy1435903lowboy
lowe75435313lo_w_e
lowed95233903lo_wed
lower85830413lo_wer
lowery124112703lowery
lowes85732463lo_wes
lown76929293lo_w_n
lows75843013lo_w_s
lowse87219903lo_wse
loyal84513483lo_yal
midway15327153midway
moggy125212163mog_gy
moray105423793mo_ray
nongay10169153nongay
nonwar9159423nonwar
noways12127733no_ways
ofay106416103_o_fay
ogam75120033_og_am
ogham1138253_ogham
oilway1235743oilway
okay115917663_o_kay
ology94113113olog__y
onlay84212943_onlay
oogamy1235633oogamy
oogeny10117923oogeny
pogey116017893pog_ey
pogy105623553pog__y
roadway1464613roadway
rollway1344653rollway
ropeway1544773ropeway
rowan85418733ro_wan
rowdy125711533ro_wdy
runway12105973runway
seaway12309993seaway
skyway1933343skyway
slipway1543873slipway
slogan7539223slog_an
slowly1237153slo_wly
soggy105413903sog_gy
someway1545613someway
sowar85821343so_war
subway1447073subway
sway107128233__sway
today96416953to_day
toga57027413tog_a_
togae67020113tog_ae
togas67823003tog_as
tokay125513053to_kay
tollway1344793tollway
towaway1644153towaway
towny116114493to_wny
towy105325473to_w_y
way96757663___way
wigwag1443723wigwag
wigwam1544723wigwam
yoga87418053yog_a_
yogas96615603yog_as

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.1401276364.3
2DLD Change Limit1127162095.50020493.8
3Display Results2092090.0633317.5
 (SQL Overall)1786912095.70331332.8
 
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.