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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

107 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
avocations1516868(None) 
advocations1755411advocations
avocation14168991avocation_
evocations15259871evocations
vocations141911421_vocations
adorations11310232adorations
advocation1645742advocation_
allocations1347772allocations
aviations12311552av_iations
avocational1645182avocational
evocation142010292evocation_
invocations1647062invocations
locations112512742_locations
revocations16410312revocations
vacations141910552_vacations
vocation132311982_vocation_
abdications1657653abdications
ablations11311513a_blations
abolitions1246653abolitions
abortions1147783abo_rtions
abrogations14116463abrogations
actions94218513a__c_tions
actuations1239293actuations
acylations1547603acylations
adnations1039753a_dnations
adoptions1245783ado_ptions
adoration10311313adoration_
adulations11310123adulations
advections1645553advec_tions
advocating1744483advocati_ng
advocators1663913advocat_ors
aerations9317903a_erations
agitations11310063agitations
agnations10310033a_gnations
alations82518893a__lations
allocation1248573allocation_
allocutions1353983allocutions
amotions1069843amo__tions
animations12312193animations
annotations1146883annotations
arcuations1249343arcuations
arrogations12126483arrogations
associations1445753associations
auctions104012143a_uc_tions
automations1348233automations
aviation11312743av_iation_
avocadoes1562343avoca_does
avocados1472983avoca_do_s
bilocations1545293bilocations
cations94524143___cations
cavitations1647843cavitations
coactions1349743_coactions
conations111318903_conations
convocations1947363convocations
donations101112353_donations
dotations101411633_dotations
educations1339233educations
elocutions1245963elocutions
evacuations1646303evacuations
evections142510693evec_tions
evictions14228623evic_tions
evocators1446713evocat_ors
evolutions13107043evolutions
flotations1366873flotations
furcations1547533furcations
invocation1547543invocation_
iodations1039113_iodations
isolations10310693isolations
lavations1238973lav__ations
lobations11219613_lobations
location102113913_location_
locutions11207063_locutions
navigations1545203navigations
notations91512973_notations
novations12139003_novations
orations81515803__orations
ovations11149263__ovations
ovulations1337973ovulations
ozonations1945143ozonations
phonations1538313phonations
placations1438583placations
plications14310493plications
potations111615073_potations
proactions1449343proactions
probations14311083probations
pronations12314033pronations
prorations12314463prorations
provocations1956873provocations
quotations19146283quotations
relocations13311143relocations
revocation15410813revocation_
rogations101510823_rogations
rotations91613843_rotations
solations9814623_solations
sulcations1289583sulcations
vacation131911893_vacation_
vallations1339083vallations
valuations1348783valuations
variations13310773variations
venations12311723_venations
vexations1937753_vexations
violations1337963violations
vocational1546953_vocational
vocatives1745883_vocatives
volitions1288663_volitions
volutions12108393_volutions
zonations18139313_zonations

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.423422437.4
2DLD Change Limit1406031076.21622619.5
3Display Results1071070.0631698.4
 (SQL Overall)1786911076.70226662.3
 
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.