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

93 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
quotation1814697(None) 
quotations19146281quotations
dotation91412732_dotation
equitation1948342equitation
flotation1267812flotation
gustation1047962gustation
guttation1046172guttation
mutation101412882mu_tation
notation81414602_notation
nutation81513102nu_tation
potation101716782_potation
rotation81615452_rotation
adoration10311313adoration
agitation10311223agitation
annotation1047753annotation
automation1249143automation
avocation14168993avocation
citation10314363_citation
conation101420883_conation
corotation12410973corotation
cunctation1476913cunctation
denotation11311083denotation
dentation10315243dentation
dictation12810563dictation
donation91513783_donation
dotations101411633_dotations
dubitation1377333dubitation
duration9312693du_ration
equation17310483equ__ation
equitations2047443equitations
eructation1248333eructation
evocation142010293evocation
exultation1747533exultation
fetation11613143_fetation
floatation1344683floatation
flotations1366873flotations
furcation1448353furcation
gestation10310663gestation
gustations1147233gustations
guttations1145593guttations
imitation11510853imitation
iodation9310383_iodation
isolation9311643isolation
jactation1838143jactation
lactation11310813lactation
lobation102110553_lobation
location102113913_location
lunation8311923lu_nation
lustration1048353lustration
luxation1538233lu_xation
mentation11313983mentation
misquotation23152833misquotation
mutations111211453mu_tations
natation81513933_natation
nictation1189273nictation
notations91512973_notations
novation111710013_novation
nunnation9126563nunnation
nutations91411763nu_tations
oration71617713__oration
outstation1046163outstation
ovation101510023__ovation
ozonation1845673ozonation
peltation11312963peltation
phonation1439393phonation
potations111615073_potations
probation13412183probation
pronation11415703pronation
proration11415983proration
pulsation1137143pulsation
punctation1486053punctation
pupation1269503pu_pation
purgation1247393purgation
question1745823qu_estion
quotidian1952423quotidian
restation9316913restation
rogation91612053_rogation
rotations91613843_rotations
ruination9311273ruination
saltation9312003saltation
siltation939213siltation
solation8916153_solation
squamation2153533squamation
station72717243__station
sublation11311013sublation
substation1248993substation
sudation9310803su_dation
sulcation11710733sulcation
sulfation1288783sulfation
summation1347803summation
violation1238443violation
vocation132311983_vocation
zonation171410723_zonation

Search took 8 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.423422437.4
2DLD Change Limit148641937.03321134.8
3Display Results93930.0462021.7
 (SQL Overall)178691937.50223819.1
 
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.