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
airpark1344913air_park
baresark1443873baresark
earmark1345633ear_mark
hardback2045623hardback
hardhack2143833hardhack
hardpack2043923hardpack
hardtack1843993hardtack
hardware1546283hardware
landmark1544133landmark
sardar73013163sard_ar_
sardars83112853sard_ars
yardarm13114523yard_arm
yardwork1944503yardwork
aardwolf1542134aardwolf
adverb12265414_a_dverb
advert103215774_a_dvert
airdate8311324aird_ate
airfare1047244air_fare
airparks1443894air_parks
airward1148114air_ward
arak86929574_ar__a_k
ardor64617864_ard_or_
ardors74416864_ard_ors
ardour74110894_ardour_
ardours8368864_ardours
ariary94114204_ar_iary
arrack121110214_ar_rack
arrear6310244_arrear_
arrears738834_arrears
arrival1037524arriva_l
arrivals1145894arrivals
arriver10117784arriver_
arrivers11137004arrivers
artwork1447074_artwork
arval86016994_ar_va_l
aurar54420254aur__ar_
awarder1135884award_er_
awarders1245064award_ers
baidarka1542484baid_arka
ballpark1643744ballpark
bareback1846074bareback
baresarks1543434baresarks
barnyard1443784barnyard
barrack1538214bar_rack
barware12610704bar_ware
birdfarm1642874birdfarm
boardwalk1951714boardwalk
boshvark2042274boshvark
calvary1537174ca_lvary
caracara1247214caracara
carack142113134car__ack
caravan1239204carava_n
caravans1338584caravans
carbarn1139454car_barn
cardboard1545824cardboard
cardcase1345944cardcase
carder94524174card_er_
carders104820324card_ers
cardia9916324cardia__
cardiac1278774cardia_c
cardiacs1376864cardiacs
cardiae10713664cardia_e
cardias10715034cardia_s
cardsharp1752534cardsharp
carfare12310064car_fare
carjack2246124car_jack
carrack1548714car_rack
carver114420134car_ver_
carvers124817504car_vers
charivari1742544charivari
darbar959934dar_bar_
darbars10510074dar_bars
dark95133214___d_ark
earmarks1444774ear_marks
farmwork2044184farmwork
farmyard1742834farmyard
garboard1247204garboard
garda7316764gard_a__
gardai839654gard_a_i
gardant9314464gard_ant
gaydar1135504gayd_ar_
gaydars1235794gayd_ars
hallmark1744204hallmark
handcar1337374handcar_
handcars1437614handcars
handcart1449324handcart
handwork1946904handwork
hardass1139744hard_ass
hardbacks2145344hardbacks
hardball14116284hardball
hardboard1645544hardboard
hardcase1445594hardcase
hardcore1445994hardcore
harder105022384hard_er_
hardhacks2243684hardhacks
hardhat14411014hardha_t
hardhats1546814hardhats
hardier114721514hardier_
hardpacks2143604hardpacks
hardpan1336444hardpa_n
hardpans1436444hardpans
hardtacks1943784hardtacks
hardwares1646564hardwares
hardwire1544624hardwire
landmarks1643604landmarks
landward1345804landward
larboard1157624larboard
larder73720974lard_er_
larders83516934lard_ers
lardier83518314lardier_
larva8312484lar_va__
larvae938824lar_va_e
larval948484lar_va_l
larvas9310234lar_va_s
marinara1046464marinara
mudlark1463904_mudlark
navar83912734na__var_
navars92810574na__vars
padauk1335634pa_d_auk
paravane1348064paravane
pardah123412814pard_a_h
pardahs13289644pard_ahs
pardner10239454pardner_
pardners11269194pardners
radar61316714ra_d_ar_
radars71314644ra_d_ars
remark123512354__remark
repark123511704__repark
salivary1444724salivary
samovar1244234samovar_
samovars1343694samovars
sandbank1544854sandbank
sandbar10108174sandbar_
sandbars11108754sandbars
sardana838634sard_ana
sarsar63011834sar_sar_
sarsars73512104sar_sars
serovar1046134serovar_
serovars1145224serovars
sirdar7269084sird_ar_
sirdars8228184sird_ars
tanbark1337364ta_nbark
tardier859719944tardier_
tartar63214734tar_tar_
tartare73012654tar_tare
tartars73313374tar_tars
trademark1651874trademark
valvar12388644va_lvar_
wardenry1542974wardenry
warder104020264ward_er_
warders113416784ward_ers
warfare1336734war_fare
warwork1757564war_work
woodlark1693294woodlark
yardage1235734yard_age
yardarms14123314yard_arms
yardbird1542304yardbird
yarder103813964yard_er_
yarders113211584yard_ers
yardland1343744yardland
yardman1335904yardma_n
yardwand1642724yardwand
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 Limit16160916510.87614859.2
3Display Results1651650.0632619.0
 (SQL Overall)17869116511.10916085.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2021  |  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.