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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
faraway164541(None) 
caraway1538131caraway
faraday1445631faraday
areaway1335912_areaway
caraways1636942caraways
fadeaway1842652fadeaway
fairway1644332fairway
fallaway1743902fallaway
faradays1544272faradays
flyaway1943162flyaway
layaway1643932layaway
parkway1934552parkway
partway1535922partway
tearaway1443692tearaway
airway1237693_airway
alway116113923_a_lway
anyway1534803_anyway
archway1844893_archway
areaways1444483_areaways
array86317143_ar_ray
away108024223___away
brawly144312353_brawly
brawny144710603_brawny
carabao1139673carabao
caracal11312513caracal
carapax1835793carapax
caravan1239223caravan
castaway1664573castaway
crawly144610763_crawly
cutaway1544433cutaway
daresay1135433daresay
drawly134910723_drawly
earwax1664733ear_wax
fadeaways1942233fadeaways
fairways1743873fairways
fallaways1843163fallaways
farad95720673far__ad
faradaic1443653faradaic
faradic1337693faradic
farads104713273fara_ds
farcy135217093far__cy
farfal123410183far_fal
farina94618233farina_
farinas103215233farinas
fatally1339893fatally
fatwa1168063fa_twa_
fatwas1249053fa_twas
fawny144711713f__awny
fishway1943813fishway
flawy145913383f_law_y
flyaways2042813flyaways
flyway18134693f_lyway
foldaway1842433foldaway
folkway2043353folkway
footway1635253footway
foray115023973for__ay
forebay1538133forebay
forwhy1834423for_why
fracas11311993f_racas
fray105428903f_r__ay
freeway1635603freeway
frowsy15498273f_rowsy
frowzy24485793f_rowzy
gangway1544233gangway
gateway1434923gateway
getaway1444013getaway
halfway1943763halfway
hallway1636173hallway
hereaway1743683hereaway
laneway1345273laneway
layaways1743403layaways
maraca10314153maraca_
maracas11313773maracas
margay12310593mar_gay
narwal938943nar_wal
parkways2043973parkways
parlay113713993par_lay
pathway1844853pathway
raceway1546133raceway
railway1345313railway
rawly115115833__rawly
runaway1343683runaway
scrawly15197183scrawly
scrawny15213933scrawny
seaway12309993_seaway
sprawly15166043sprawly
strawy1210312823straw_y
takeaway1843053takeaway
tarama8412723tarama_
taramas9612693taramas
taxiway2043463taxiway
tearaways1542963tearaways
thataway1742943thataway
thruway1643163thruway
towaway1644153towaway
tramway1544863tramway
walkaway2142643walkaway
walkway2043373walkway
wireway1646043wireway

Search took 8 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 Filter1786911340270.1561145455.1
2DLD Change Limit134027996.89319443.9
3Display Results99990.0462152.2
 (SQL Overall)178691997.09525185.5
 
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.