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

96 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
raceway154613(None) 
raceways1645231raceways
archway1844892archway
gateway1434932gateway
laneway1345272laneway
racewalk1744062racewalk
railway1345312railway
ropeway1544772ropeway
trackway20113782trackway
aceta74017353_aceta_
acetal84314903_acetal
airway1237693_airway
alway116113923_a_lway
anyway1534803_anyway
archways1944063archways
areaway1335913areaway
away108024223_a__way
bikeway1944313bikeway
cableway1843323cableway
caraway1538133caraway
causeway1643253causeway
crawlway1941993crawlway
cycleway2172553cycleway
daresay1135433daresay
dracena1034923dracena_
dracenas1145793dracenas
driveway1841993driveway
fadeaway1842653fadeaway
fairway1644333fairway
faraway1645413faraway
freeway1635603freeway
gangway1544233gangway
gateways1544613gateways
halfway1943763halfway
hallway1636173hallway
hatchway2243293hatchway
lacey105820913lace__y
laneways1444573laneways
layaway1643933layaway
leeway1255883_leeway
lifeway1644273lifeway
pacey126720283pace__y
packwax2542853packwax
paleways1645833paleways
parkway1934553parkway
partway1535923partway
pathway1844853pathway
race66746263race___
raced87635313race__d
racemate1239063racemate
raceme1039733race_me
racemed1237013racemed
racemes1139093racemes
racemic1336983racemic
racer75233023race__r
racers84725433race_rs
races74943243race__s
racewalks1843533racewalks
rachial122012173rachial
racial83419243rac_ial
racily11715173rac_ily
rackety16499113rackety
racy95825683rac___y
railways1444603railways
rarefy12296343rare_fy
rarely93513653rare_ly
ravelly13268353ravelly
rawly115115833ra__wly
recency1438633recency
relay84424673r__elay
renewal1038703renewal
repay104818453r__epay
resay85320543r__esay
rewan85623663r__ewan
rewax155713923r__ewax
roadway1464613roadway
rockaway2042343rockaway
rollway1344653rollway
ropeways1644053ropeways
rosebay12135773rosebay
routeway1443413routeway
runaway1343683runaway
runway12105973r_unway
sideway1445673sideway
someway1545613someway
takeaway1843053takeaway
taxiway2043463taxiway
tideway1445153tideway
tracery12399793trace_ry
trackways21103433trackways
trainway1444223trainway
tramway1544863tra_mway
walkway2043373walkway
wasteway1743313wasteway
waterway1745563waterway
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.406440125.6
2DLD Change Limit134027966.70319995.1
3Display Results96960.0303200.0
 (SQL Overall)178691967.13925030.3
 
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.