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

164 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
carwash153599(None) 
awash116613162_a_wash
calash11312432ca_lash
carcase11312732carcase
carcass11310512carcass
carlish12312762carlish
caroach1488862caroach
carwashes1745772carwashes
crash109120012c_r_ash
abash106016513_a_bash
areas55935773_areas_
arias55438023_arias_
arras55626133_arras_
backwash2244943backwash
barcas101016603barcas_
barware12610703barware
brash106221563_br_ash
cacas95627983ca_cas_
caddish143810123caddish
calabash1544253calabash
calipash1543223calipash
callas84526753callas_
camas96333523ca_mas_
camass104114183ca_mass
cannas84518403cannas_
canvas113813333canvas_
canvass12376873canvass
capias10318353capias_
carack142113173car_ack
carafe115416163car_afe
carat75048793car_a_t
carate84734003car_ate
carats85929023car_ats
caraway1538133caraway
caraways1636943caraways
carbarn1139453carbarn
carbos105122263carbos_
carbs96031463car_bs_
carcases12313083carcases
cardcase1345963cardcase
cardias10715113cardias_
cards85137933car_ds_
carers85133963carers_
cares77369183car_es_
caress85720263car_ess
carets85330773carets_
carfare12310073carfare
cargos94619183cargos_
caries85147623caries_
carinas93622403carinas_
caritas93316953caritas_
carjack2246153carjack
carks115534213car_ks_
carles85435083carles_
carless95118493carless
carls77037423car_ls_
carman103920743carma_n
carnage10311743carnage
carnal83919203carna_l
carns75937563car_ns_
carobs104818103carobs_
caroch13911763car_och
carols85124983carols_
caroms105619573caroms_
carouse9614423carouse
carpal103716253carpa_l
carpale113414353carpale
carpals113414623carpals
carps96932253car_ps_
carpus105514303carpus_
carrack1548753carrack
carroch1437093carroch
carrs75730853car_rs_
cars67364763car__s_
carse74934333car__se
carses85233653carses_
cartage10312593cartage
cartes86239473cartes_
carts78946293car_ts_
carves115128453carves_
casas75327843ca_sas_
casbah1337903casba_h
casbahs1436463casbahs
casease939323casease
cash96636283c___ash
catfish1559023catfish
cattish12410723cattish
catwalk1645323catwalk
caws96036103ca_w_s_
cerias83321983cerias_
charas114223613char_as_
charkas164810963charkas_
clash106219033c__lash
crass76328043c_r_ass
crawfish1944233crawfish
crawls114712083crawls_
craws105723123craw_s_
crease85519573c_rease
creasy114612303c_reasy
creesh11328333c_reesh
crush106815993c_r_ush
crwth1337483c_rw_th
crwths1433433c_rwths
curagh1236553cur_agh
currach1446453currach
curragh1344293curragh
currish1238353currish
czardas1934673czardas_
darkish1537943darkish
earwax1664733earwa_x
eyewash1642583eyewash
fatwas1249053fatwas_
flatwash1742423flatwash
garfish14179203garfish
garish104516923gar_ish
garnish111610843garnish
harass9313943har_ass
hardass1139753hardass
harsh116418053har__sh
hogwash1742713hogwash
jarrah1636683jarra_h
jarrahs1735453jarrahs
karmas123013733karmas_
kurbash1643803kurbash
largish1138603largish
larkish1439083larkish
larvas9310233larvas_
lavash12597373la_vash
maras75443283mar_as_
marish114319053mar_ish
markas124717003markas_
marsh105320853mar__sh
narwal938943narwa_l
narwals1036983narwals
oarfish13158613oarfish
outwash13187613outwash
paraph13311263par_aph
paras76143043par_as_
pardah123412823parda_h
pardahs13289673pardahs
pariah114320583paria_h
pariahs123812343pariahs
parish115022353par_ish
parkas125018023parkas_
pearlash1344133pearlash
prewash1535213prewash
rainwash1443063rainwash
rash76039933__r_ash
rawish123012913ra_wish
rewash1237673_rewash
sarcasm1136693sarcasm
swash116316753__swash
tarbush1234173tarbush
tarnish101611873tarnish
tartish101512633tartish
thrash12258363thr_ash
trash86119763_tr_ash
varas86028193var_as_
varias95019903varias_
varnas94212823varnas_
varnish13169533varnish
warmish1538373warmish
warpath1545203warpath
wash106033813___wash

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.1401276364.3
2DLD Change Limit1340271646.56320421.6
3Display Results1641640.0632603.2
 (SQL Overall)1786911646.76626410.1
 
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.