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

96 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
arcuations124934(None) 
arcuation11410581arcuation_
accusations1546002accusations
actuations1239292actuations
abductions15125383abductions
abjurations2045143abjurations
ablations11311513a_blations
ablutions1146603ablu_tions
abrogations14116463abrogations
abruptions1443843abruptions
accretions1444923accretions
accusation1466903accusation_
actions94218513a_c__tions
actuation11310333actuation_
acylations1547603acylations
adductions14104953adductions
adjurations1944823adjurations
adnations1039753a_dnations
adorations11310233adorations
adulations11310123adulations
aerations9317903a_erations
agitations11310063agitations
agnations10310033a_gnations
alations82518893a__lations
ambulations1547113ambulations
amputations1546443amputations
angulations1268053angulations
animations12312193animations
annulations1167833annulations
arcadians1245083arc_adians
arrogations12126483arrogations
articulations1546733articulations
auctions104012143a__uctions
aviations12311553a_viations
avocations15168683avocations
calculations1647073calculations
carnations12311353car_nations
cations94524143__c_ations
cautions103313183__cautions
circulations1648483circulations
coarctations16114493coarctations
creations112614543cr_eations
cremations14410713cremations
crenations12511693crenations
darnations1138413dar_nations
dictations1389703dictations
educations1339233educations
equations1839493_equations
eructations1347233eructations
eruptions1146763er_uptions
evacuations1646303evacuations
fasciations1646263fasciations
fruitions12106113fr_uitions
furcations1547533furc_ations
gradations1286863gradations
graduations1385233graduations
incautions1245973incautions
incubations1547303incubations
irruptions1243893irruptions
jactations1936893jactations
lactations1239423lactations
liquations1945623liquations
locations112512743loc_ations
locutions11207063locu_tions
maculations1569623maculations
marinations13411273marinations
mercurations1646563mercurations
narrations1038943nar_rations
nictations1278313nictations
occupations1744543occupations
orations81515803or__ations
osculations1348373osculations
peculations15310283peculations
precautions1546553precautions
predations13812153predations
privations15310103privations
probations14311083probations
procurations1647403procurations
pronations12314033pronations
prorations12314463prorations
radiations11311923radiations
rations74123433_r__ations
recautions1247813recautions
relations92418333_relations
rogations101510823_rogations
rotations91613843_rotations
ructions102811683_r_uctions
sacculations1646663sacculations
sinuations1039413sinuations
situations1038433situations
tarnations1038903tar_nations
urinations10310693urinations
vacations141910553vac_ations
valuations1348783valuations
variations13310773var_iations
vocations141911423voc_ations

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 Filter1786911406030.420425454.8
2DLD Change Limit140603966.42321890.5
3Display Results96960.0462087.0
 (SQL Overall)178691966.88925938.6
 
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.