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 “aardvark” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

165 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
aardvark16231597(None) 
aardvarks171855611aardvarks
airpark1344923air_park
baresark1443883baresark
earmark1345653ear_mark
hardback2045633hardback
hardhack2143843hardhack
hardpack2043923hardpack
hardtack1843993hardtack
hardware1546283hardware
landmark1544153landmark
sardar73013173sard_ar_
sardars83112903sard_ars
yardarm13114533yard_arm
yardwork1944503yardwork
aardwolf1542134aardwolf
adverb12265414_a_dverb
advert103215784_a_dvert
airdate8311324aird_ate
airfare1047244air_fare
airparks1443914air_parks
airward1148134air_ward
arak86929574_ar__a_k
ardor64617864_ard_or_
ardors74416874_ard_ors
ardour74110904_ardour_
ardours8368884_ardours
ariary94114204_ar_iary
arrack121110254_ar_rack
arrear6310254_arrear_
arrears738844_arrears
arrival1037564arriva_l
arrivals1145934arrivals
arriver10117794arriver_
arrivers11137004arrivers
artwork1447084_artwork
arval86017014_ar_va_l
aurar54420254aur__ar_
awarder1135894award_er_
awarders1245074award_ers
baidarka1542504baid_arka
ballpark1643754ballpark
bareback1846094bareback
baresarks1543434baresarks
barnyard1443784barnyard
barrack1538254bar_rack
barware12610704bar_ware
birdfarm1642874birdfarm
boardwalk1951714boardwalk
boshvark2042284boshvark
calvary1537184ca_lvary
caracara1247244caracara
carack142113174car__ack
caravan1239224carava_n
caravans1338614caravans
carbarn1139454car_barn
cardboard1545864cardboard
cardcase1345964cardcase
carder94524184card_er_
carders104820354card_ers
cardia9916374cardia__
cardiac1278814cardia_c
cardiacs1376914cardiacs
cardiae10713704cardia_e
cardias10715114cardia_s
cardsharp1752534cardsharp
carfare12310074car_fare
carjack2246154car_jack
carrack1548754car_rack
carver114420144car_ver_
carvers124817534car_vers
charivari1742574charivari
darbar959954dar_bar_
darbars10510094dar_bars
dark95133214___d_ark
earmarks1444794ear_marks
farmwork2044184farmwork
farmyard1742834farmyard
garboard1247244garboard
garda7316764gard_a__
gardai839664gard_a_i
gardant9314464gard_ant
gaydar1135504gayd_ar_
gaydars1235804gayd_ars
hallmark1744214hallmark
handcar1337374handcar_
handcars1437624handcars
handcart1449324handcart
handwork1946904handwork
hardass1139754hard_ass
hardbacks2145374hardbacks
hardball14116304hardball
hardboard1645584hardboard
hardcase1445624hardcase
hardcore1446044hardcore
harder105022404hard_er_
hardhacks2243704hardhacks
hardhat14411024hardha_t
hardhats1546834hardhats
hardier114721544hardier_
hardpacks2143624hardpacks
hardpan1336444hardpa_n
hardpans1436454hardpans
hardtacks1943804hardtacks
hardwares1646564hardwares
hardwire1544624hardwire
landmarks1643614landmarks
landward1345824landward
larboard1157664larboard
larder73720974lard_er_
larders83516944lard_ers
lardier83518344lardier_
larva8312484lar_va__
larvae938844lar_va_e
larval948504lar_va_l
larvas9310234lar_va_s
marinara1046494marinara
mudlark1463914_mudlark
navar83912734na__var_
navars92810574na__vars
padauk1335644pa_d_auk
paravane1348094paravane
pardah123412824pard_a_h
pardahs13289674pard_ahs
pardner10239474pardner_
pardners11269194pardners
radar61316724ra_d_ar_
radars71314674ra_d_ars
remark123512374__remark
repark123511714__repark
salivary1444734salivary
samovar1244244samovar_
samovars1343704samovars
sandbank1544874sandbank
sandbar10108194sandbar_
sandbars11108784sandbars
sardana838644sard_ana
sarsar63011844sar_sar_
sarsars73512144sar_sars
serovar1046144serovar_
serovars1145234serovars
sirdar7269104sird_ar_
sirdars8228214sird_ars
tanbark1337374ta_nbark
tardier859719994tardier_
tartar63214754tar_tar_
tartare73012684tar_tare
tartars73313404tar_tars
trademark1651914trademark
valvar12388654va_lvar_
wardenry1542974wardenry
warder104020274ward_er_
warders113416814ward_ers
warfare1336734war_fare
warwork1757574war_work
woodlark1693304woodlark
yardage1235734yard_age
yardarms14123334yard_arms
yardbird1542324yardbird
yarder103813974yard_er_
yarders113211594yard_ers
yardland1343764yardland
yardman1335914yardma_n
yardwand1642744yardwand
yardworks2044484yardworks

Search took 12 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 Filter1786911616090.1701051123.5
2DLD Change Limit16160916511.53314012.7
3Display Results1651650.0632619.0
 (SQL Overall)17869116511.76615187.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.