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

235 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
potations11161507(None) 
dotations101411631dotations
notations91512971notations
potation101716781potation_
rotations91613841rotations
citations11312502citations
conations111318902conations
donations101112352donations
dotation91412732dotation_
fetations12511382fetations
flotations1366872flotations
iodations1039112iodations
lobations11219612lobations
locations112512742locations
mutations111211452mutations
natations91412492natations
notation81414602notation_
novations12139002novations
nutations91411762nutations
orations81515802_orations
ovations11149262_ovations
peltations12311552peltations
petitions11511082petitions
phonations1538312phonations
portions10514412po_rtions
positions11811502positions
potatoes1039942potat_oes
potions93417422po__tions
probations14311082probations
pronations12314032pronations
prorations12314462prorations
pupations1338122pupations
quotations19146282quotations
rogations101510822rogations
rotation81615452rotation_
solations9814622solations
stations82415222_stations
vocations141911422vocations
zonations18139312zonations
ablations11311513ablations
actuations1239293actuations
adnations1039753adnations
adorations11310233adorations
aerations9317903aerations
agitations11310063agitations
agnations10310033agnations
alations82518893_alations
amputations1546443amputations
annotations1146883annotations
aviations12311553aviations
avocations15168683avocations
betatrons1145083betatrons
capitations1549853capitations
cations94524143__cations
citation10314363citation_
coactions1349743coactions
coaptations1547543coaptations
cogitations1448903cogitations
cognations1339593cognations
coitions10312853co_itions
collations12312853collations
conation101420883conation_
connations12312943connations
contagions1346603contagions
cooptions13107763cooptions
copatrons1346333copatrons
corotations1349763corotations
cottons9312193cot_t_ons
creations112614543creations
delations102616593delations
denotations1239853denotations
dentations11413633dentations
deportations1548463deportations
deputations1448343deputations
dictations1389703dictations
dilations102614453dilations
donation91513783donation_
durations10311463durations
elations83719123_elations
enations83316903_enations
epilations12311713epilations
equations1839493equations
evocations15259873evocations
exportations2146653exportations
fetation11613143fetation_
fixations1936353fixations
floatations1444103floatations
flotation1267813flotation_
foliations1399943foliations
formations1538203formations
gelations102513093gelations
gestations1139773gestations
gustations1147233gustations
guttations1145593guttations
gyrations1336923gyrations
halations12312393halations
himations1438803himations
ideations1039903ideations
illations9311393illations
imitations1259963imitations
importations16156143importations
imputations1546353imputations
iodation9310383iodation_
isolations10310693isolations
jactations1936893jactations
kations114013663__kations
lactations1239423lactations
lavations1238973lavations
laxations1637623laxations
legations102711923legations
libations112510443libations
ligations102111993ligations
lobation102110553lobation_
location102113913location_
locutions11207063locutions
lotions74614763lo__tions
lunations9310723lunations
luxations1637273luxations
mentations12312583mentations
monitions11310883monitions
motions94215003mo__tions
motivations1647093motivations
mutation101412883mutation_
natation81513933natation_
nations74720563__nations
negations102811963negations
nictations1278313nictations
nidations1039213nidations
nitrations10312033nitrations
nonactions1248373nonactions
notating92513343notati_ng
notational1048123notational
notions74014483no__tions
novation111710013novation_
nutation81513103nutation_
oblations1139373oblations
operations12312953operations
optatives1445203optatives
options93810603_o_ptions
oration71617713_oration_
ovation101510023_ovation_
ozonations1945143ozonations
pactions122613503p_actions
palmations1438733palmations
palpations1437653palpations
parathions1545323parathions
partitions1248323partitions
patinations13411003patinations
patins87528783p__ati_ns
patios85221783p__atio_s
patrons93818103p__atrons
peltation11312963peltation_
perorations13314063perorations
petition10711753petition_
phonathons1843453phonathons
phonation1439393phonation_
pinnations1236883pinnations
placations1438583placations
planations1238723planations
plantations1347473plantations
platoons1038683p_latoons
plications14310493plications
polarons1039863pola_rons
pollutions1245433pollutions
pontons93315553po_nt_ons
pontoons10279313po_ntoons
populations15148713populations
portion9615493po_rtion_
position10912193position_
positrons1186543positrons
postilions12116283postilions
postins93721203po_sti_ns
postulations14127733postulations
potato8513433potat_o__
potatory1348413potat_ory
potion84519573po__tion_
potstone1039423potst_one
potstones1149213potst_ones
potteens10256793pot_teens
potties93723543pot_ti_es
potting103720893pot_ti_ng
pottos84615873pot_t_o_s
predations13812153predations
privations15310103privations
proactions1449343proactions
probation13412183probation_
promotions1448783promotions
pronation11415703pronation_
proration11415983proration_
prostrations1449763prostrations
protamins131410773protami_ns
protections15510703protections
protonations1449073protonations
protractions1646643protractions
pulsations1236373pulsations
punctations1585353punctations
punitions1137923punitions
pupation1269503pupation_
purgations1346743purgations
quotation18146973quotation_
rations74123433__rations
relations92418333relations
reputations13410733reputations
restations10315843restations
rogation91612053rogation_
rotating92614553rotati_ng
rotational1048093rotational
rotators8310203rotat_ors
saltations10310623saltations
satiations10312113satiations
sedations10311253sedations
siltations1038553siltations
situations1038433situations
solation8916153solation_
solutions988883solutions
solvations1336833solvations
sorptions1137123sorptions
sortitions1046423sortitions
spoliations1347693spoliations
statins73719773_stati_ns
station72717243_station_
sudations1039903sudations
tactions102912423__tactions
talions7314113__talions
taxations1636863taxations
titrations1039173titrations
vacations141910553vacations
venations12311723venations
vexations1937753vexations
violations1337963violations
vitiations1338743vitiations
vocation132311983vocation_
volitions1288663volitions
volutions12108393volutions
zonation171410723zonation_

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 Limit1486412356.75022020.9
3Display Results2352350.1102136.4
 (SQL Overall)1786912357.28324535.4
 
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.