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

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

95 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
tatars6461979(None) 
attars64515311attars
talars66021681talars
tartars73313401tartars
tatar56122061tatar_
taters64932191taters
afars85716512_afars
agars66120642_agars
altars64518152altars
ataps76414832_ataps
attar56516692attar_
avatars1036442avatars
bazars174613112bazars
caters85336492caters
damars93814992damars
datary10310242datary
daters74827362daters
eaters65535942eaters
gaters74728632gaters
gators74115822gators
gazars164811552gazars
haars85620472ha_ars
haters94930392haters
kabars124513952kabars
kantars11310032kantars
katas95922092kata_s
lahars94013162lahars
lazars153812392lazars
maars74621632ma_ars
makars124612632makars
malars85020682malars
maters85032382maters
navars92810572navars
oaters65029782oaters
ottars64112222ottars
paters84935822paters
radars71314662radars
ratals64219582ratals
ratans63819372ratans
raters63936572raters
satara6315532satara
sataras7315052sataras
satays94411682satays
satyrs937962satyrs
sitars65417592sitars
stars55836572_stars
staters73922322staters
stators73915552stators
tabard9313332tabard
tabards10310382tabards
tabers84621572tabers
tabors84517092tabors
tahrs85412332ta_hrs
takas95520682taka_s
takers103923742takers
talar56225382talar_
talas55935892tala_s
talers64628142talers
tamals84116622tamals
tamari8313382tamari
tamaris9413572tamaris
tamers84224032tamers
tantara72410812tantara
tantaras8269532tantaras
tantras73112092tantras
tapas74627712tapa_s
tapers84025812tapers
tapirs84113172tapirs
tars46763952__tars
tartans72615822tartans
tartar63214752tartar_
tartare73012682tartare
tasters74225642tasters
tatami839182tatami
tatamis939712tatamis
tater54138612tater_
tates55444982tat_es
tats46858132tat__s
tatters74520482tatters
tawers94118602tawers
taxers134015282taxers
tears55436462t_ears
tetras63017612tetras
titans63414912titans
titers64526402titers
tolars64817922tolars
totals63115162totals
toters65026362toters
tsars56717102t_sars
tuatara745502tuatara
tuataras844852tuataras
tutors6912322tutors
tzars144914272t_zars
wataps11248682wataps
waters95030622waters

Search took 4 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 Filter178691825510.1101624463.6
2DLD Change Limit82551953.00027517.0
3Display Results95950.0303166.7
 (SQL Overall)178691953.14056908.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.