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

100 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
arcuation1141058(None) 
arcuations1249341arcuations
accusation1466902accusation
actuation11310332actuation
abduction14125413abduction
abjuration1945883abjuration
ablation10312433a_blation
ablution1047223ablu_tion
abrogation13107343abrogation
abruption1343973abruption
accretion1345943accretion
accusations1546003accusations
action84719683a_c__tion
actuations1239293actuations
acylation1448653acylation
adduction13225163adduction
adjuration1845523adjuration
adnation9310783a_dnation
adoration10311313adoration
adulation10311013adulation
aeration8319933a_eration
agitation10311223agitation
agnation9311723a_gnation
alation72920553a__lation
ambulation1447873ambulation
amputation1447343amputation
angulation1149553angulation
animation11313683animation
annulation1068953annulation
arcadian1147763arc_adian
archaeon13134073archa_eon
arcuate9311963arcuat__e
arcuated1138813arcuat_ed
arcuately1443413arcuately
arrogation11107443arrogation
articulation1447973articulation
auction93412933a__uction
aviation11312753a_viation
avocation14168993avocation
calculation1548293calculation
carnation11312943car_nation
cation83925503__c_ation
caution93013523__caution
circulation1549393circulation
coarctation1595073coarctation
creation102816513cr_eation
cremation13511643cremation
crenation11412923crenation
darnation1039823dar_nation
dictation12810563dictation
education12310203education
equation17310483_equation
eructation1248333eructation
eruption1047043er_uption
evacuation1547163evacuation
fasciation1546833fasciation
fruition11106103fr_uition
furcation1448353furc_ation
gradation11107713gradation
graduation1285793graduation
incaution1146583incaution
incubation1448363incubation
irruption1143783irruption
jactation1838143jactation
lactation11310813lactation
liquation1846553liquation
location102113913loc_ation
locution10227663locu_tion
maculation14510983maculation
marination12312813marination
mercuration1547493mercuration
narration9310063nar_ration
nictation1189273nictation
occupation1645183occupation
oration71617713or__ation
osculation1249673osculation
peculation14311993peculation
precaution1447243precaution
predation12313463predation
privation14311173privation
probation13412183probation
procuration1548293procuration
pronation11415703pronation
proration11415983proration
radiation10313403radiation
ration64226013_r__ation
recaution1148093recaution
relation82619773_relation
rogation91612053_rogation
rotation81615453_rotation
ruction93611613_r_uction
sacculation1547843sacculation
sinuation9310413sinuation
situation949423situation
tarnation9310093tar_nation
urination9312173urination
vacation131911893vac_ation
valuation1249973valuation
variation12312393var_iation
vocation132311983voc_ation

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411007.62619491.3
3Display Results1001000.0462173.9
 (SQL Overall)1786911008.10822038.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.