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

72 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
acrobats125834(None) 
acrobat11411811acrobat_
aerobats1049841aerobats
achromats1647622achromats
acrobatic1587732acrobatic
acrobatics16105292acrobatics
aerobat9514472aerobat_
aerosats8411012aerosats
airboats1047282airboats
arrobas969212arroba_s
abrogate11129603abrogate
abrogates12108973abrogates
accosts11107993acco_sts
accounts1285843accounts
acerbate1247533acerbate
acerbates1347263acerbates
acerolas1048053acerola_s
achromat15410103achromat_
acrodonts1244523acrodonts
acrogens1147243acrogens
acrolects1344333acrolects
acrolith1348453acrolith
acroliths1445113acroliths
acronyms1544993acronyms
across8312643acro__ss
acrylate1347693acrylate
acrylates1446683acrylates
aerobatic1399003aerobatic
aerobatics1465813aerobatics
aerobes9311493aerob_es
aerobics1246833aerobics
aeronauts975163aeronauts
aerosat7417183aerosat_
aerostats946713aerostats
airbags1036293air_bags
airboat9512133airboat_
allobars1046583allobars
approbate1546563approbate
approbates1645853approbates
ararobas1046183araroba_s
arhats9312973a_r_hats
aroints7313133a_roints
aromas81018613a_roma_s
aroynts1036633a_roynts
arroba898663arroba__
arrogate91210323arrogate
arrogates10129423arrogates
ascorbate1344463ascorbate
ascorbates1444143ascorbates
auroras7311703aurora_s
automats10410443automats
carabaos1238083carabaos
carats85929023car__ats
carobs104818103carob__s
catboats1247873catboats
coats75635003_c_o_ats
cobalts1139203_c_obalts
combats13311683_combats
corbans11313173_corbans
cravats1237403_cravats
croaks125812983_cro_aks
crofts114910593_cro_fts
crowbars1544443_crowbars
groats74816653_gro_ats
iceboats1244973iceboats
microbars1546883microbars
probate11414483_probate
probates12414283_probates
probits112712573_probits
rabats83116223__rabats
robots8313153__robots
throats104612193thro_ats

Search took 9 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 Filter1786911461620.406440125.6
2DLD Change Limit146162728.00018270.3
3Display Results72720.0302400.0
 (SQL Overall)178691728.43621182.0
 
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.