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

95 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
wireway164604(None) 
wireways1745831wireways
airway1237692air_way
bikeway1944312bikeway
lifeway1644272lifeway
sideway1445672sideway
tideway1445152tideway
virelay1335942virelay
windway1745152windway
wireman1237842wireman
wiretap12145722wiretap
airplay1245483airplay
airways1336243air_ways
aisleway1442523aisleway
areaway1335913_areaway
bikeways2043653bikeways
caraway1538133caraway
daresay1135433daresay
direly10311563dire_ly
driveway1841993driveway
fairway1644333fair_way
faraway1645413faraway
fireclay1644183fireclay
firefly1635633firefly
fireman1249333fireman
firepan1236983firepan
firewall14125933firewall
fishway1943813fishway
forebay1538133forebay
freeway1635603freeway
gateway1434933gateway
giveaway1841903giveaway
guideway1642433guideway
hereaway1743683hereaway
hideaway1842713hideaway
highway2044263highway
laneway1345273laneway
leeway1255883_leeway
lifeways1743893lifeways
midway15327153mi_dway
oilway1235743oi_lway
parkway1934553parkway
partway1535923partway
prepay13310313_prepay
prewar114712583_prewar
raceway1546133raceway
relay84424673__relay
repay104818453__repay
resay85320543__resay
rewan85623663__rewan
rewax155713923__rewax
ropeway1544773ropeway
screwy14659463screw_y
sideways1545233sideways
sinewy12667513sinew_y
slideway1543163slideway
someway1545613someway
thruway1643163thruway
tideways1544563tideways
tiredly1136803tiredly
viewy14518103vi_ew_y
virelai1045593virelai
virelays1444643virelays
walkway2043373walkway
wasteway1743313wasteway
waterway1745563waterway
widely133311033wide_ly
widthway2141943widthway
wieldy13476183wi_eldy
wifely15429423wife_ly
wifey144913673wife__y
wigwag1443723wi_gwag
wigwam1544723wi_gwam
windways1845043windways
winery125014283wine_ry
winesap1264443winesap
winey115325433wine__y
wire75839823wire___
wired95327643wire__d
wiredraw1553513wiredraw
wirehair1443343wirehair
wiremen1236903wiremen
wirer85124953wire__r
wirers94617893wire_rs
wires86034913wire__s
wiretaps13144733wiretaps
wirework1846573wirework
wireworm1645893wireworm
wirily123310783wir_ily
wirra83210823wir_ra_
wiry106422843wir___y
wiseguy1442353wiseguy
wisely122711713wise_ly
workday1843303workday
wreak125513273w_re_ak

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.390458182.1
2DLD Change Limit134027956.95319276.1
3Display Results95950.0303166.7
 (SQL Overall)178691957.37324235.9
 
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.