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

168 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
flyway1813469(None) 
flyaway1943161flyaway
flyways19133851flyways
alway116113922al_way
anyway1534802anyway
byway1647532_byway
flawy145913382flaw_y
flay106332802fl__ay
flyaways2042812flyaways
flyboy17113912flyboy
flyby1676002fly_by
flyman14326422flyman
folkway2043352folkway
keyway1943822keyway
skyway1933342skyway
airway1237693airway
allay85620393al_lay
alleyway1752823alleyway
always12409133al_ways
anyways1644423anyways
away108024223__away
beltway1564373beltway
blowby16467513blowby
blowsy14579453blowsy
blowy134315323blow_y
blowzy23516673blowzy
byways1734673_byways
clay95927413cl__ay
cogway1566183cogway
fairway1644333fairway
fallaway1743903fallaway
faraway1645413faraway
fatwa1168063fatwa_
fatwas1249053fatwas
fawny144711713f_awny
fay97454863f___ay
feyly14429513fey_ly
fishway1943813fishway
flab96628353fl__ab
flabby1634573flabby
flag87427083fl__ag
flaggy14415923flaggy
flak116026173fl__ak
flakey164410513flakey
flaky155715583fl_aky
flam96333293fl__am
flamy135217473fl_amy
flan76134183fl__an
flap96128703fl__ap
flappy1654483flappy
flashy15498173flashy
flat77147823fl__at
flatly123110213flatly
flatways1744323flatways
flaw106326643fl__aw
flawed134712723flawed
flaws115920343flaw_s
flax147325633fl__ax
flaxy189012293fl_axy
flays116321053fl__ays
flea75628493fl_ea_
fleam106017283fl_eam
fleas86423663fl_eas
flecky18387653flecky
fledgy14414913fledgy
fleecy14266483fleecy
fleshy15406283fleshy
fleury12417353fleury
flew105824253flew__
flews115316443flew_s
fley106626853fl__ey
flimsy14345563flimsy
flinty126112493flinty
flippy1654613flippy
flirty12499143flirty
float85928573fl_oat
floaty124210943floaty
flocky18468423flocky
floodway1842683floodway
flooey123910173flooey
floosy12368153floosy
floozy21356613floozy
floppy1654873floppy
flora85317103flora_
florae94713883florae
floral94313813floral
floras94715693floras
flossy12517703flossy
flota85315643flota_
flotas94013003flotas
floury12449573floury
flow105924923flow__
flowage1435723flowage
flowed133513763flowed
flower124815503flower
flowery16327783flowery
flown116213993flow_n
flows115822363flow_s
fluffy14315783fluffy
flukey16459813flukey
fluky154512293fl_uky
flunky16408093flunky
flurry12397113flurry
flutey125212523flutey
fluty114415643fl_uty
fly97124953fl___y
flyboat1546003flyboat
flyboys18112943flyboys
flybys1792773flybys
flyer114916253fly_er
flyers125712803flyers
flying134612153flying
flyleaf1642583flyleaf
flymen14387773flymen
flyoff1444023flyoff
flypast1583753flypast
flysch1732893flysch
flyte115713943fly_te
flyted13378773flyted
flytes123911563flytes
flytrap1543253flytrap
foldaway1842433foldaway
folkways2143143folkways
footway1635253footway
foray115023973f_oray
forwhy1834423forwhy
fray105428903f__ray
freeway1635603freeway
frowsy15498273frowsy
frowzy24485793frowzy
frypan1434543frypan
glycan1234903glycan
halfway1943763halfway
hallway1636173hallway
heyday1635143heyday
holyday1743773holyday
jetway19105273jetway
keyways2043373keyways
lawny115912013_lawny
lay68865353_l__ay
layaway1643933layaway
leeway1255883leeway
logway1335913logway
lowly114113333_lowly
mayday1535883mayday
midway15327153midway
naysay1234973naysay
noway111112843_noway
oilway1235743oilway
payday1536613payday
play95928983pl__ay
playday1643823playday
psywar1443323psywar
rollway1344653rollway
runway12105973runway
seaway12309993seaway
skyways2043223skyways
slay76436383sl__ay
slipway1543873slipway
slowly1237153slowly
slyly11489533sly_ly
subway1447073subway
sway107128233__sway
tollway1344793tollway
walkway2043373walkway
way96757663___way
waylay1535453waylay
yay96948713__y_ay

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.373479064.3
2DLD Change Limit1127161685.00022543.2
3Display Results1681680.0632666.7
 (SQL Overall)1786911685.43632871.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.