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

188 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
rogations10151082(None) 
rogation91612051rogation_
rotations91613841rotations
abrogations14116462abrogations
arrogations12126482arrogations
cognations1339592cognations
conations111318902conations
derogations1349392derogations
donations101112352donations
dotations101411632dotations
iodations1039112iodations
legations102711922legations
ligations102111992ligations
lobations11219612lobations
locations112512742locations
negations102811962negations
notations91512972notations
novations12139002novations
orations81515802_orations
ovations11149262_ovations
potations111615072potations
probations14311082probations
pronations12314032pronations
prorations12314462prorations
rations74123432r__ations
relations92418332relations
rotation81615452rotation_
solations9814622solations
vocations141911422vocations
zonations18139312zonations
ablations11311513ablations
abrogation13107333abrogation_
adnations1039753adnations
adorations11310233adorations
aerations9317903aerations
agnations10310033agnations
alations82518893_alations
arcuations1249343arcuations
arrogation11107443arrogation_
aviations12311553aviations
avocations15168683avocations
cations94524143__cations
citations11312503citations
coactions1349743coactions
cogitations1448903cogitations
cognation12310753cognation_
cognitions1346043cognitions
coitions10312853co_itions
collations12312853collations
conation101420883conation_
connations12312943connations
cooptions13107763cooptions
copatrons1346333copatrons
coronations13410703coronations
corotations1349763corotations
creations112614543creations
cremations14410713cremations
crenations12511693crenations
delations102616593delations
derogation12410393derogation_
dilations102614453dilations
donation91513783donation_
dotation91412733dotation_
durations10311463durations
elations83719123_elations
elongations1244663elongations
enations83316903_enations
equations1839493equations
evocations15259873evocations
fetations12511383fetations
fixations1936353fixations
flotations1366873flotations
foliations1399943foliations
formations1538203formations
gabions102410053__gabions
gelations102513093gelations
gigatons1046053gigat_ons
gradations1286863gradations
gyrations1336923gyrations
halations12312393halations
himations1438803himations
ideations1039903ideations
illations9311393illations
iodation9310383iodation_
irrigations1246943irrigations
isolations10310693isolations
kations114013663__kations
lavations1238973lavations
laxations1637623laxations
legation92412933legation_
libations112510443libations
ligation92313093ligation_
lobation102110553lobation_
location102113913location_
locutions11207063locutions
logions86211293log__ions
lotions74614763lo__tions
lunations9310723lunations
luxations1637273luxations
megatons11279703megat_ons
migrations13168683migrations
monitions11310883monitions
motions94215003mo__tions
mutations111211453mutations
natations91412493natations
nations74720563__nations
negation92913023negation_
negatons9299273negat_ons
negatrons10275843negatrons
nidations1039213nidations
nonactions1248373nonactions
notation81414603notation_
notions74014483no__tions
novation111710013novation_
nutations91411763nutations
oblations1139373oblations
options93810603_o_ptions
oration71617713_oration_
organons945583orga_nons
ovation101510023_ovation_
ozonations1945143ozonations
perorations13314063perorations
phonations1538313phonations
portions10514413po_rtions
positions11811503positions
potation101716783potation_
potions93417423po__tions
predations13812153predations
privations15310103privations
proactions1449343proactions
probation13412183probation_
promotions1448783promotions
pronation11415703pronation_
propagations1745553propagations
proration11415983proration_
prorogations1556723prorogations
pupations1338123pupations
purgations1346743purgations
quotations19146283quotations
radiations11311923radiations
ration64226013r__ation_
ratios64922673r__atio_s
ratoons73815473r__atoons
rattons73815323r__attons
reactions11711713reactions
recautions1247813recautions
redactions1359133redactions
reflations13311233reflations
regains84316583rega_i_ns
regions83613473reg__ions
regulations12310713regulations
relation82619773relation_
relegations1248973relegations
relocations13311143relocations
remotions1149703remotions
renovations1448423renovations
restations10315843restations
revocations16410313revocations
rigadoons1142633rigadoons
rigatoni944623rigat_oni
rigatonis1044503rigat_onis
rigaudons1141943rigaudons
rogatory1246153rogat_ory
ronions73313343ro__nions
rosarians945793rosarians
rotating92614553rotati_ng
rotational1048093rotational
rotators8310203rotat_ors
ructions102811683r_uctions
ruinations1039603ruinations
sedations10311253sedations
solation8916153solation_
solutions988883solutions
solvations1336833solvations
sorptions1137123sorptions
stations82415223_stations
subrogations1545453subrogations
sudations1039903sudations
taxations1636863taxations
urinations10310693urinations
vacations141910553vacations
venations12311723venations
vexations1937753vexations
violations1337963violations
vocation132311983vocation_
volitions1288663volitions
volutions12108393volutions
zonation171410723zonation_

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 Filter1786911486410.403443402.0
2DLD Change Limit1486411886.42323142.0
3Display Results1881880.0932021.5
 (SQL Overall)1786911886.91925826.1
 
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.