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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
earmark134565(None) 
earmarks1444791earmarks
earmarked1643222earmarked
seamark1336722sea_mark
aardvark162315973aardvark
airpark1344923airpark
arak86929573_ar_a_k
ariary94114203_ariary
armada938783_armada
armer76924443_armer_
armers85520273_armers
armor75118053_armor_
armors85017813_armors
armory114211473_armory
armure8710133_armure
arrack121110253_arrack
baresark1443883baresark
barmaid1238203barmaid
barman103519703barma_n
barrack1538253barrack
barware12610703barware
carack142113173car_ack
carbarn1139453carbarn
carfare12310073carfare
carjack2246153carjack
carman103920743carma_n
carrack1548753carrack
damar84117733da_mar_
damars93814993da_mars
damask1335843da_mask
dammar11438903dammar_
dammars12308193dammars
darbar959953darbar_
darbars10510093darbars
daymare1375633daymare
demark134211023_demark
earlap837183earla_p
earlaps936393earlaps
earlock1336923earlock
earmarking1743583earmarking
earmuff1543063earmuff
earner63617223earner_
earners74016453earners
earwax1664733earwa_x
earworm1238743earworm
embark14458523e_mbark
farmer115017373farmer_
farmers124315263farmers
farmwork2044193farmwork
farmyard1742833farmyard
finmark16154883finmark
gramary1355903gramary
hallmark1744213hallmark
harmer114719553harmer_
harmers124116593harmers
karma113415003karma__
karmas123013733karma_s
landmark1544153landmark
mammary1335993mammary
mark105138063___mark
metalmark1752363metalmark
mismark1536703mismark
ostmark1344873ostmark
palmar104113463palmar_
palmary14338553palmary
pearmain1245833pearmain
pugmark1643463pugmark
rearward1245783rearward
remark123512373_remark
samara8313853sa_mara
sardar73013173sardar_
sardars83112903sardars
sarsar63011843sarsar_
sarsars73512143sarsars
seamarks1445303sea_marks
tamari8313403ta_mari
tanbark1337373tanbark
tarmac10310333tarma_c
tarmacs1138323tarmacs
tartar63214753tartar_
tartare73012683tartare
tartars73313403tartars
telemark1444123telemark
warfare1336733warfare
warmer113816733warmer_
warmers124514293warmers
warwork1757583warwork
watermark1844123watermark
yardarm13114533yardarm
yasmak1534593yasma_k

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.390458182.1
2DLD Change Limit134027906.12621878.4
3Display Results90900.0461956.5
 (SQL Overall)178691906.56227231.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.