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

157 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
caraway153813(None) 
caraways1636941caraways
faraway1645411faraway
areaway1335912_areaway
carabao1139672carabao
caracal11312512caracal
carapax1835792carapax
caravan1239222caravan
castaway1664572castaway
crawly144610762c_rawly
cutaway1544432cutaway
faraday1445632faraday
layaway1643932layaway
parkway1934552parkway
partway1535922partway
tearaway1443692tearaway
airway1237693_airway
alway116113923_a_lway
anyway1534803_anyway
archway1844893_archway
areaways1444483_areaways
array86317143_ar_ray
away108024223___away
brawly144312353_brawly
brawny144710603_brawny
cabala103516913cabala_
cabalas113516003cabalas
cabana103913563cabana_
cabanas112413033cabanas
cableway1843323cableway
calamar1149293calamar
calamary1545463calamary
canary11314693cana_ry
capably1639253capably
carabaos1238073carabaos
carabid12311333carabid
carabin11313213carabin
caracals12310743caracals
caracara1247243caracara
carack142113173cara_ck
caracks152211563caracks
caracol11310423caracol
caracul1138823caracul
carafe115416163cara_fe
carafes125015703carafes
caragana1146273caragana
caramba1336893caramba
caramel11310253caramel
carapace1446083carapace
carat75048793car__at
carate84734003cara_te
carates95630613carates
carats85929023cara_ts
caravans1338613caravans
caravel1238203caravel
carboy134914183car_boy
cardia9916373cardia_
cardiac1278813cardiac
cardiae10713703cardiae
cardias10715113cardias
carina84325323carina_
carinae94318583carinae
carinal94318233carinal
carinas93622403carinas
caritas93316953caritas
carload1039783carload
carman103920743car_man
carnal83919203car_nal
carnally1339513carnally
carney115315703car_ney
carnify1555883carnify
carny105822923car__ny
carpal103716253car_pal
carroty1248943carroty
carry105823783car__ry
carwash1535993carwash
casaba1079263casaba_
casabas1139983casabas
casava1157873casava_
casavas1237813casavas
castaways1743673castaways
catawba1443703catawba
catawbas1544093catawbas
causeway1643253causeway
cavally1588483cavally
cavalry1554963cavalry
ceramal1138843ceramal
cogway1566183c_ogway
craal74117753c_ra_al
crabby15346753c_rabby
cracky175010223c_racky
crafty14478913c_rafty
craggy13396603c_raggy
crampy154710993c_rampy
cranky153910633c_ranky
cranny114210273c_ranny
crappy15446803c_rappy
cravat11314443c_ravat
craw97725263c_raw__
crawdad1443113c_rawdad
crawl104916713c_raw_l
crawls114712083c_rawls
crawlway1941993crawlway
craws105723123c_raw_s
crazy195511223c_ra_zy
crowdy15467173c_rowdy
curably142010773curably
curacao1146293curacao
curacy1339593cura_cy
curara83712203curara_
curaras93911953curaras
cutaways1643813cutaways
daresay1135433daresay
drawly134910723_drawly
earwax1664733ear_wax
fadeaway1842653fadeaway
fairway1644333fairway
fallaway1743903fallaway
faradays1544273faradays
flyaway1943163flyaway
gangway1544233gangway
gateway1434933gateway
getaway1444013getaway
halfway1943763halfway
hallway1636173hallway
hereaway1743683hereaway
laneway1345273laneway
layaways1743403layaways
maraca10314153maraca_
maracas11313773maracas
margay12310593mar_gay
narwal938943nar_wal
parkways2043973parkways
parlay113713993par_lay
pathway1844853pathway
raceway1546133raceway
railway1345313railway
rawly115115833__rawly
runaway1343683runaway
scalawag14142773scalawag
scrawly15197183scrawly
scrawny15213933scrawny
seaway12309993_seaway
sprawly15166043sprawly
strawy1210312823straw_y
takeaway1843053takeaway
tarama8412733tarama_
taramas9612703taramas
taxiway2043463taxiway
tearaways1542973tearaways
thataway1742953thataway
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 Limit1340271577.73317331.8
3Display Results1571570.0632492.1
 (SQL Overall)1786911577.95222471.2
 
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.