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

105 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
freeway163560(None) 
freeways1744721freeways
areaway1335912areaway
freely12310962free_ly
freeman1237342freeman
freeware1446172freeware
greenway1543852greenway
leeway1255882_leeway
archway1844893archway
areaways1444483areaways
bikeway1944313bikeway
breezeway2681163breezeway
breezy20295853bree_zy
brewery15376963brewery
creedal1037093creedal
creepy13418803cree_py
deejay1734523_deejay
deewan10267553_deewan
driveway1841993driveway
fadeaway1842653fadeaway
fairway1644333fairway
faraway1645413faraway
feebly1436653f_eebly
fireclay1644183fireclay
fishway1943813fishway
fleecy14266483flee_cy
fleetly1336323fleetly
flyaway1943163flyaway
flyway18134693f_lyway
folkway2043353folkway
footway1635253footway
forebay1538133forebay
foreplay1645673foreplay
forestay1448193forestay
fraena938063fraena_
fray105428903fr___ay
freak125115243fr_e_ak
freaky16439233fr_eaky
freckly19124593freckly
free75940183free___
freebase1344853freebase
freebee1238043freebee
freebie1236043freebie
freed95223543free__d
freedman1444143freedman
freedom1345863freedom
freehand1574993freehand
freeing113713913freeing
freeload1244733freeload
freemen1238463freemen
freer86021243free__r
freers94717303free_rs
frees86131393free__s
freesia1046323freesia
freesias1146333freesias
freest95318283free_st
freewares1545943freewares
freewill1443413freewill
freeze18349513free_ze
freezer19348523freezer
freezes193310353freezes
frena85915273fr_ena_
frenzy2135883fr_enzy
freshly16286833freshly
fretsaw1343923fretsaw
fretty1249223fr_etty
frowsy15498273fr_owsy
frowzy24485793fr_owzy
gateway1434933gateway
greedy11518853gree_dy
greenly11408193greenly
greenways1643433greenways
greeny104811453gree_ny
hereaway1743683hereaway
jetway19105273_jetway
keyway1943823_keyway
laneway1345273laneway
leeways1354453_leeways
lifeway1644273lifeway
prepay13310313pr_epay
prewar114712583pr_ewar
raceway1546133raceway
redbay1238333_redbay
reechy14367823_reechy
reedy910020293_ree_dy
reefy114217703_ree_fy
reeky125416263_ree_ky
relay84424673_r_elay
renewal1038703_renewal
repay104818453_r_epay
replay113412923_replay
resay85320543_r_esay
rewan85623663_r_ewan
rewax155713923_r_ewax
rewear93012003_rewear
ropeway1544773ropeway
runway12105973_runway
seaway12309993_seaway
sideway1445673sideway
someway1545613someway
speedway1743313speedway
tideway1445153tideway
tramway1544863tramway
veejay1933703_veejay
wireway1646043wireway

Search took 7 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 Limit1340271056.04622167.9
3Display Results1051050.0303500.0
 (SQL Overall)1786911056.48227567.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.