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

189 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
rogation9161205(None) 
rogations101510821rogations
rotation81615451rotation
abrogation13107332abrogation
arrogation11107442arrogation
cognation12310752cognation
conation101420882conation
derogation12410392derogation
donation91513782donation
dotation91412732dotation
iodation9310382iodation
legation92412932legation
ligation92313092ligation
lobation102110552lobation
location102113912location
negation92913022negation
notation81414602notation
novation111710012novation
oration71617712_oration
ovation101510022_ovation
potation101716782potation
probation13412182probation
pronation11415702pronation
proration11415982proration
ration64226012r__ation
relation82619772relation
rotations91613842rotations
solation8916152solation
vocation132311982vocation
zonation171410722zonation
ablation10312433ablation
abrogations14116463abrogations
adnation9310783adnation
adoration10311313adoration
aeration8319933aeration
agnation9311723agnation
alation72920553_alation
arcuation11410583arcuation
arrogations12126483arrogations
aviation11312743aviation
avocation14168993avocation
cation83925503__cation
citation10314363citation
coaction12310773coaction
cogitation13410083cogitation
cognations1339593cognations
cognition1247013cognition
coition9314313co_ition
collation11313993collation
conations111318903conations
connation11314263connation
cooption1288343cooption
copatron1246753copatron
coronation12412073coronation
corotation12410973corotation
creation102816513creation
cremation13511643cremation
crenation11412923crenation
delation92318083delation
derogations1349393derogations
dilation92215463dilation
donations101112353donations
dotations101411633dotations
duration9312693duration
elation73620453_elation
elongation1145353elongation
enation73419233_enation
equation17310483equation
evocation142010293evocation
fetation11613143fetation
fixation1837073fixation
flotation1267813flotation
foliation121110793foliation
formation1439423formation
gabion93211033__gabion
gelation93014433gelation
gigaton946343gigat_on
gradation11107713gradation
gyration1237763gyration
halation11313853halation
himation1339753himation
ideation9310493ideation
illation8311943illation
iodations1039113iodations
irrigation1147803irrigation
isolation9311643isolation
kation104315683__kation
lavation1139973lavation
laxation1538423laxation
legations102711923legations
libation102411363libation
ligations102111993ligations
lobations11219613lobations
locations112512743locations
locution10227663locution
logion76013723log__ion
lotion65716523lo__tion
lunation8311923lunation
luxation1538233luxation
megaton10269853megat_on
migration12179703migration
monition10311723monition
motion85217553mo__tion
mutation101412883mutation
natation81513933natation
nation64322803__nation
negations102811963negations
negaton8299143negat_on
negatron9335993negatron
nidation9410583nidation
nonaction1149443nonaction
notations91512973notations
notion64516583no__tion
novations12139003novations
nutation81513103nutation
oblation1039863oblation
option83612713_o_ption
orations81515803_orations
organon845913orga_non
ovations11149263_ovations
ozonation1845673ozonation
peroration12316003peroration
phonation1439393phonation
portion9615493po_rtion
position10912193position
potations111615073potations
potion84519573po__tion
predation12313463predation
privation14311173privation
proaction13410103proaction
probations14311083probations
promotion1359503promotion
pronations12314033pronations
propagation1646443propagation
prorations12314463prorations
prorogation1447393prorogation
pupation1269503pupation
purgation1247393purgation
quotation18146973quotation
radiation10313393radiation
ratio55227583r__atio_
rations74123433r__ations
ratios64922673r__atios
ratoon64417373r__atoon
ratton64116123r__atton
reaction10612603reaction
recaution1148093recaution
redaction1259663redaction
reflation12412333reflation
regain74517763rega_i_n
region74614903reg__ion
regulation11312053regulation
relations92418333relations
relegation11610023relegation
relocation12312113relocation
remotion10410233remotion
renovation1358783renovation
restation9316913restation
revocation15410813revocation
rigadoon1043193rigadoon
rigatoni944623rigat_oni
rigaudon1042473rigaudon
rogatory1246153rogatory
ronion63315643ro__nion
rosarian847593rosarian
rotating92614553rotating
rotational1048093rotational
rotative11310343rotative
rotator7310833rotat_or
ruction93611613r_uction
ruination9311273ruination
sedation9312453sedation
solations9814623solations
solution889593solution
solvation1237773solvation
sorption1037513sorption
station72717243_station
subrogation1446003subrogation
sudation9310803sudation
taxation1537993taxation
urination9312173urination
vacation131911893vacation
venation11513503venation
vexation1838783vexation
violation1238443violation
vocations141911423vocations
volition1179173volition
volution1198603volution
zonations18139313zonations

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 Filter1786911461620.453394461.4
2DLD Change Limit1461621896.76621602.4
3Display Results1891890.0762486.8
 (SQL Overall)1786911897.29524495.0
 
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.